Comments by Tarannum Mujawar (Top 1 by date)

When I execute the following sql lines
;WITH cte AS
(
SELECT *,
ROW_NUMBER() OVER (PARTITION BY Name ORDER BY Date DESC) AS rn
FROM dbdate
)
SELECT *
FROM cte
WHERE rn = 1
I get the following error:
"The OVER SQL construct or statement is not supported."