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

1 vote195 views1 answer
Oracle stop
SQL
0 vote188 views1 answer
Sql datediff month
SQL
0 vote244 views1 answer
Using distinct and count together in sql
SQL
0 vote190 views1 answer
Google sheets filter rows above current cell
SQL
0 vote216 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote184 views2 answers
Tsql row number
SQL
1 vote199 views1 answer
Mysql query bulk insert
SQL
0 vote182 views1 answer
Pgadmin see indexes
SQL
3 votes185 views1 answer
Oracle sleep
SQL
1 vote184 views1 answer
Mysql copy table1 to table2
SQL