I am fighting with the distinct keyword in
I just want to display all row numbers of unique (
distinct) values in a column & so I tried:
SELECT distinct id, ROW_NUMBER() OVER (ORDER BY id) AS RowNum FROM table where fid = 64
however the below code giving me the
SELECT distinct id FROM table where fid = 64
but when tried it with
then it is not working.