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 vote162 views1 answer
Postgresql regular expression special characters
SQL
0 vote213 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
8 votes183 views1 answer
Oracle tablespace datafile max size
SQL
0 vote201 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote175 views4 answers
Stored procedure sql
SQL
0 vote154 views1 answer
Sql server python connection
SQL
1 vote176 views1 answer
Oracle stop
SQL
0 vote174 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote184 views1 answer
Helptext in sql
SQL
5 votes175 views1 answer
Oracle nls instance
SQL