I am getting error for this query
Hi,
Pls tell any alternate for row_number for this query
SELECT top 2 EventTitle,STUFF(EventDescription,120,4000,'....') AS 'Description',GalleryTitle,LEFT(Gallerytitle,(charindex('_',Gallerytitle)-1)) as Title,EventYear,EventDescription,gallerytitle, gallery FROM (SELECT photography_events.*,row_number() OVER (PARTITION BY gallerytitle ORDER BY gallery DESC) AS RN FROM photography_events) AS t WHERE RN = 1 ORDER BY EID
Pls help me