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 vote146 views1 answer
Order by oracle
SQL
0 vote158 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
1 vote224 views2 answers
Sql server find all foreign keys that reference a column
SQL
1 vote177 views1 answer
How to delay stored procedure execution in sql server
SQL
1 vote168 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote160 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
2 votes168 views1 answer
Use cases condition in sql query laravel
SQL
0 vote159 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote152 views1 answer
Postgresql isnull with max
SQL
2 votes183 views3 answers
Application.properties spring boot mysql
SQL