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 votes203 views3 answers
Mysql auto increment after delete
SQL
1 vote177 views2 answers
Begin transaction in sql
SQL
4 votes202 views1 answer
Mysql set max connections
SQL
5 votes129 views1 answer
Copy table from one database to another mysql
SQL
0 vote169 views1 answer
Access refused mysql xampp server
SQL
1 vote247 views1 answer
Show databases mysql docker
SQL
1 vote185 views1 answer
Mysql find most common value
SQL
4 votes173 views1 answer
Update table from another table oracle
SQL
0 vote170 views1 answer
Trigger value from maltiple table to single table mysql
SQL
10 votes176 views1 answer
User_dependencies
SQL