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

0 vote125 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
53 votes303 views6 answers
How to install mysql ubuntu
SQL
1 vote125 views1 answer
Mariadb case switch
SQL
17 votes139 views5 answers
Order by sql
SQL
-1 vote134 views5 answers
Convert sql to linq query online
SQL
1 vote125 views1 answer
Replace all numbers in mysql
SQL
0 vote112 views1 answer
QCompleter con sql
SQL
1 vote141 views1 answer
Sql select max value from multiple rows
SQL
0 vote130 views1 answer
Mysql update privileges
SQL
2 votes150 views1 answer
Laravel sql String
SQL