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 vote187 views1 answer
Find a column in all tables postgres
SQL
15 votes213 views4 answers
Sql update from select
SQL
0 vote179 views1 answer
Sql server check whether column has same equal values
SQL
1 vote273 views1 answer
Mysql is odd
SQL
0 vote207 views1 answer
Plpgsql if statement
SQL
0 vote174 views2 answers
Mysql output csv
SQL
1 vote196 views1 answer
How to see which columns are indexxed mysql
SQL
2 votes176 views1 answer
Sql find missing values between two tables
SQL
1 vote163 views1 answer
Select dba users oracle
SQL
23 votes216 views6 answers
Create table sql
SQL