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

20 votes169 views4 answers
Sql count if
SQL
0 vote163 views1 answer
Psql check table fields
SQL
0 vote188 views1 answer
Set Mamp mysql globally
SQL
10 votes152 views2 answers
Sql rtrim
SQL
0 vote157 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote145 views3 answers
Sql all columns
SQL
1 vote142 views1 answer
Mysql get character set
SQL
0 vote155 views2 answers
Py sqlite if entry exists
SQL
7 votes150 views4 answers
How to reset the identity column in sql server
SQL
18 votes171 views6 answers
Laravel form validation
SQL