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

5 votes265 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
58 votes443 views4 answers
Mysql drop column
SQL
0 vote262 views1 answer
Less mysql display
SQL
1 vote267 views1 answer
Update mysql centos
SQL
0 vote284 views1 answer
Use mysql in java program
SQL
14 votes279 views2 answers
Oracle limit rows
SQL
7 votes251 views4 answers
Database dump mysql command
SQL
0 vote275 views1 answer
Delete duplicate rows
SQL
0 vote256 views1 answer
How many rows affected in sqllite
SQL
0 vote254 views1 answer
How to stop all connections to a psql 12 database?
SQL