Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links

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

Solutions


Your Answer

10099
Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links