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 vote309 views2 answers
Influxdb delete measurement based on date
SQL
6 votes425 views4 answers
Mysql get random row
SQL
7 votes379 views5 answers
Max 3 salary in sql
SQL
0 vote360 views1 answer
Psql attribute cannot login
SQL
1 vote386 views1 answer
Sqlalchemy on delete set null
SQL
1 vote377 views1 answer
Sqlserver create table from select
SQL
0 vote363 views1 answer
Every Derived yable must have its own alias
SQL
0 vote366 views1 answer
Check if a column is a primary key in sql server
SQL
2 votes385 views3 answers
How to check current user in mySQL
SQL
4 votes348 views2 answers
What is table in sql
SQL