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 vote253 views1 answer
Add new column in sql with foreign key
SQL
0 vote220 views1 answer
Replace multiple string in query sql
SQL
0 vote253 views1 answer
Implode in sql query
SQL
0 vote255 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote239 views1 answer
Snowflake rename column name
SQL
4 votes226 views1 answer
Postgresql create table with index
SQL
0 vote250 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote745 views1 answer
Mysql custom sort order
SQL
0 vote229 views1 answer
How to create a new shema using query languaage
SQL
0 vote225 views1 answer
Tsql generate rows
SQL