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 vote190 views1 answer
Postgres drop type
SQL
1 vote177 views1 answer
Sql delete row with auto increment
SQL
0 vote187 views1 answer
Authentication in sql server
SQL
3 votes217 views1 answer
What is having
SQL
1 vote197 views1 answer
Clear screen command in psql
SQL
0 vote187 views1 answer
Sql how to display two atributes as one in sql
SQL
21 votes196 views6 answers
Docker run mysql
SQL
7 votes197 views2 answers
Add column table pl sql
SQL
0 vote211 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote196 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL