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 votes193 views3 answers
Mysql declare variable
SQL
0 vote181 views2 answers
Sql 2 way of select unique
SQL
0 vote183 views1 answer
Android sqlite get rows count
SQL
0 vote189 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote191 views1 answer
Get the Db column names from a SqlDataReader
SQL
1 vote184 views1 answer
How do you use sql in you company
SQL
0 vote229 views1 answer
Redshift running queries
SQL
0 vote172 views1 answer
How to access to mysql without root
SQL
0 vote181 views1 answer
Sql create table with references not primary key
SQL
0 vote171 views1 answer
Oracle list dblink
SQL