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 vote136 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote142 views1 answer
Select into table variable
SQL
0 vote126 views1 answer
Mysql jdbc timezone
SQL
0 vote168 views1 answer
Tsql cte in a transaction
SQL
5 votes138 views2 answers
Ranking functions in sql
SQL
0 vote146 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote137 views1 answer
Php mysqli install
SQL
2 votes137 views2 answers
Select list is not in group by clause
SQL
0 vote143 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote128 views1 answer
Replace multiple string in query sql
SQL