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

2 votes202 views1 answer
Foreign key example in dbms
SQL
10 votes252 views4 answers
Primary key in sql
SQL
1 vote217 views1 answer
Find logged in users mysql
SQL
0 vote250 views1 answer
Mysql milliseconds
SQL
1 vote290 views1 answer
Drop colum oracle 18c
SQL
0 vote245 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
1 vote239 views1 answer
How to update date add hours in postgresql
SQL
0 vote239 views1 answer
Django mssql backend
SQL
18 votes233 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote228 views1 answer
How to see password mysql vestacp
SQL