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 vote144 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote141 views1 answer
Psql attribute cannot login
SQL
12 votes146 views2 answers
Insert multiple rows from another table sql
SQL
5 votes149 views3 answers
Mysql extract month from date
SQL
2 votes155 views1 answer
Mysql change data type of column
SQL
9 votes193 views1 answer
No sql
SQL
1 vote154 views1 answer
Postgresql how to show table names
SQL
0 vote139 views1 answer
Mysql Error Code: 1005
SQL
9 votes192 views3 answers
Postgres make sql dump
SQL
3 votes145 views2 answers
Oracle sql drop sequence
SQL