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

1 vote280 views1 answer
How to run parallel queries in sql server with entity framework
SQL
6 votes280 views1 answer
What is where clause in sql
SQL
0 vote288 views1 answer
Synapse sql table set pk
SQL
7 votes271 views1 answer
Append column sql
SQL
2 votes281 views1 answer
Wait delay in sql server
SQL
0 vote294 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote343 views1 answer
Sql doesn't contain
SQL
1 vote294 views1 answer
Rows to comma separated values in mssql
SQL
3 votes300 views2 answers
Postgres download
SQL
0 vote287 views1 answer
What is the difference between now() and current_date()?
SQL