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

6 votes108 views1 answer
Oracle pl sql source
SQL
0 vote104 views1 answer
How to convert DateTime to VarChar SQL
SQL
2 votes96 views1 answer
Oracle current date without time
SQL
3 votes99 views1 answer
Sql print all names that start with a given letter
SQL
1 vote111 views1 answer
Print year of a date sql
SQL
0 vote109 views1 answer
Query by column for substring sql
SQL
-1 vote79 views1 answer
Mysql if example
SQL
0 vote114 views1 answer
Mysql change timestamp on update
SQL
2 votes102 views3 answers
Current month mysql query
SQL
2 votes103 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL