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 vote119 views1 answer
Sql run multiple updates in one query
SQL
1 vote129 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
-1 vote115 views1 answer
Condition in orderby mysql
SQL
0 vote123 views1 answer
Mysql order by rand limit 1 really slow
SQL
1 vote100 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote116 views1 answer
Mysql streaming example
SQL
0 vote114 views1 answer
Select from column mysql
SQL
4 votes151 views1 answer
How to drop a database in sql server when it is in use
SQL
25 votes134 views6 answers
How to change column name in mysql
SQL
0 vote109 views1 answer
Add plugins to mysql workbench
SQL