I have a query in SQL Server 2012:-
SELECT DISTINCT
FIELD_1, FIELD_2
FROM
TABLE_A
Now I want to get row number for each record. So I have used ROW_NUMBER()
function for this purpose.
SELECT DISTINCT
ROW_NUMBER() OVER (ORDER BY FIELD_1, FIELD_2) AS rowId
FIELD_1, FIELD_2
FROM
TABLE_A
This query does not give me distinct result.
How to retrieve distinct result with row number ?
When you are using
DISTINCT
you should not forget that it will apply after window functions likeROW_NUMBER
that makes all your rows unique.So try this: