Avatar of Medrise
Medrise

asked on 

SQL DISTINCT not working

I have a query that I'm added ROW_NUMBER() to it, but when I try to add DISTINCT or GROUP BY it does not work.

Here is the query.

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY fpacode) AS Rownumber, fpaCode, listname, fpaID, emailTo, status, cfid FROM fpaBasket WHERE cfid = 'D1W12978461') AS Sample WHERE Rownumber < 11

Open in new window

Microsoft SQL ServerColdFusion LanguageSQL

Avatar of undefined
Last Comment
PortletPaul

8/22/2022 - Mon