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 vote404 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote355 views1 answer
My sql data file extention
SQL
0 vote363 views1 answer
Sql alter column name sql server
SQL
0 vote347 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
-3 votes322 views1 answer
Remove spaces sql 2008
SQL
0 vote363 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote353 views1 answer
How to set sql_mode for a query in CI model
SQL
1 vote341 views1 answer
Sql query row number group by
SQL
0 vote347 views1 answer
Mysql table variables
SQL
1 vote367 views1 answer
Oracle enable job
SQL