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 order by list
SQL
0 vote193 views1 answer
Mariadb errno 121
SQL
1 vote280 views1 answer
Oracle transaction rollback not working
SQL
0 vote205 views1 answer
Sql bild in function
SQL
9 votes214 views6 answers
Sql insert into
SQL
0 vote229 views1 answer
Openquery update linked server
SQL
0 vote203 views1 answer
10000000000000000000 am to meters
SQL
13 votes207 views3 answers
Uninstall mysql centos 7
SQL
0 vote184 views1 answer
Oracle activate program
SQL
0 vote179 views1 answer
If exist column in table drop sql query mysql
SQL