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

12 votes159 views6 answers
Change mysql root password
SQL
0 vote240 views1 answer
Mysql edit trigger
SQL
1 vote181 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote178 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote147 views1 answer
Sql common columns
SQL
0 vote145 views1 answer
Guid string to binary better
SQL
0 vote133 views1 answer
Get who is hired in specific month in sql
SQL
4 votes151 views1 answer
Adding data to table in sql python
SQL
0 vote109 views1 answer
Postgresql add leading zeros
SQL
0 vote157 views1 answer
Space not removing from column in sql
SQL