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

0 vote165 views1 answer
Mysql equivalent decode oracle
SQL
0 vote174 views1 answer
Postgres docs /copy metacomand
SQL
0 vote183 views1 answer
Sqlalchemy query return only n results
SQL
0 vote135 views1 answer
To change the database owner in SQL server
SQL
0 vote207 views1 answer
Alter table name including schema
SQL
0 vote142 views1 answer
Select a row include list of array with join table SQL
SQL
57 votes321 views5 answers
How to create a new user in postgresql
SQL
3 votes149 views6 answers
DB::table('users')->get();
SQL
0 vote147 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote137 views1 answer
MySQL error code 2068
SQL