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 vote280 views1 answer
Find a column in all tables postgres
SQL
0 vote308 views1 answer
Pgadmin check database
SQL
6 votes341 views3 answers
What is where in sql
SQL
2 votes288 views2 answers
Postgres trigger insert into another table
SQL
6 votes260 views1 answer
How to count number of rows in sql
SQL
5 votes268 views1 answer
How to use rank function in sql
SQL
0 vote266 views1 answer
SQL isnumeric DB2
SQL
0 vote270 views1 answer
T sql less than date
SQL
-1 vote266 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote268 views1 answer
Oracle activate program
SQL