How to get top 1 record of each group in sql?
;WITH cte AS
(
SELECT *,
ROW_NUMBER() OVER (PARTITION BY ID ORDER BY Date DESC)
AS rn
FROM Table
)
SELECT *
FROM cte
WHERE rn = 1
By Adil Shahbaz 05-Dec-2023 2