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

9 votes294 views3 answers
Sql delete where in
SQL
7 votes276 views3 answers
Sql server reset auto increment
SQL
0 vote302 views1 answer
Sql show founctions
SQL
0 vote259 views1 answer
Sql track modification
SQL
-1 vote266 views1 answer
Window functions in sql
SQL
0 vote301 views1 answer
New rails app with mysql
SQL
1 vote256 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
9 votes255 views3 answers
Sequence postgresql
SQL
0 vote256 views1 answer
Python mysql executemany
SQL
0 vote279 views4 answers
Postgresql between month
SQL