How to Get Top 1 Row of Each Group in SQL Server

SQL : Get top 1 row of each groupПодробнее

How to get LAST ROW in SQLПодробнее

SQL: Select Top 10 Records for Each CategoryПодробнее

How to get FIRST ROW in SQLПодробнее

Practice Activity - Retrieving the last row for each group in a table in SQL ServerПодробнее