Get top 1 row of each group

;WITH cte AS
(
   SELECT *,
         ROW_NUMBER() OVER (PARTITION BY DocumentID ORDER BY DateCreated DESC) AS rn
   FROM DocumentStatusLogs
)
SELECT *
FROM cte
WHERE rn = 1

Source: stackoverflow.com

Get top 1 row of each group

|ID| DocumentID | Status | DateCreated || 2| 1     | S1   | 7/29/2011  || 3| 1     | S2   | 7/30/2011  || 6| 1     | S1   | 8/02/2011  || 1| 2     | S1   | 7/28/2011  || 4| 2     | S2   | 7/30/2011  || 5| 2     | S3   | 8/01/2011  || 6| 3     | S1   | 8/02/2011  |;WITH cte AS
(
   SELECT *,
         ROW_NUMBER() OVER (PARTITION BY DocumentID ORDER BY DateCreated DESC) AS rn
   FROM DocumentStatusLogs
)
SELECT *
FROM cte
WHERE rn = 1

Source: stackoverflow.com

Similar codes

3 votes399 views1 answer
Laravel paginate raw sql
SQL
13 votes342 views4 answers
Mysql get last row
SQL
2 votes361 views1 answer
Oracle create directory
SQL
0 vote361 views1 answer
Access mysql database docker container shell
SQL
1 vote370 views2 answers
Group_concat limit mysql
SQL
0 vote373 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
2 votes376 views1 answer
How to delete columns in sql
SQL
0 vote382 views1 answer
What is top n result in sql
SQL
1 vote351 views1 answer
Show structure of table in sql
SQL
0 vote373 views1 answer
How to query without duplicate rows in sql
SQL