New posts in Greatest N Per Group

SELECT DISTINCT ON, ordered by another column

SQL Server - Select most recent record from each group when performance is critical

Can I combine SELECT TOP() with the IN operator?

Get rows with most recent date for each different item

Better database for "keep always the 5 latest entries per ID and delete older"?

How to make DISTINCT ON faster in PostgreSQL?

Get second highest value in a table

Exists subselect vs inner join?

How to select first row from a join that returns multple rows on the primary key

Retrieving n rows per group