New posts in Greatest N Per Group

GROUP BY one column, while sorting by another in PostgreSQL

In PostgreSQL, is there a type-safe first() aggregate function?

Select which has max date or latest date

How group with min(date) and select an another column in the same table

How to select the first row of each group?

SqlAlchemy group_by and return max date

Laravel 5 eager loading with limit

SQL SELECT TOP 1 FOR EACH GROUP

Optimize GROUP BY query to retrieve latest row per user

Get values from first and last row per group