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 vote111 views1 answer
Tsql replace value in json
SQL
0 vote122 views1 answer
Mysql backup certain tables workbench
SQL
0 vote127 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote108 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote120 views3 answers
Convert sql query to python pandas
SQL
0 vote121 views1 answer
Sql server bool select
SQL
0 vote118 views1 answer
Get sum sqlite android
SQL
3 votes121 views4 answers
Mysql decimal
SQL
1 vote114 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote118 views1 answer
Oracle webcenter content search enginer
SQL