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

4 votes177 views1 answer
SQL order random
SQL
-1 vote193 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
25 votes214 views1 answer
How to update an attribute in MySQL
SQL
0 vote217 views1 answer
In query in sql
SQL
0 vote183 views1 answer
Import mysql'
SQL
0 vote192 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
1 vote195 views1 answer
Postgres first_value in gropby
SQL
0 vote191 views1 answer
The local psql command could not be located
SQL
0 vote203 views1 answer
Mysql trigger to delete old data
SQL
12 votes192 views1 answer
Docker mysql random root password
SQL