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 vote326 views2 answers
Mysql dump structure only
SQL
0 vote336 views1 answer
Get date ISO in psql
SQL
0 vote330 views1 answer
Alter table engine mysql
SQL
24 votes349 views6 answers
Replace mysql
SQL
2 votes324 views1 answer
How to make multiple keys as primary in bdms
SQL
17 votes325 views3 answers
Cast in sql server
SQL
1 vote330 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
9 votes319 views4 answers
Last mysql
SQL
0 vote332 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote289 views1 answer
Select mysql limit to 2 decimal places
SQL