Group by but selecting the most recent row
7064
Retrieving the last record in each group - MySQL
145393
Filter query result by most recent date
30078
How do I perform a GROUP BY on an aliased column in MS-SQL Server?
126909
Select a value for the max
48707
Linq Query Group By and Selecting First Items
77455
Only inserting a row if it's not already there
157105
Pivot, categorize and group by
112483
PostgreSQL, SELECT from max id
93921
Select groups based on number of unique / distinct values
62686
MySQL SELECT last few days?
118546
In SQL, how can you "group by" in ranges?
127084
Returning the 'last' row of each 'group by' in MySQL
63173
PHP & MYSQL: using group by for categories
126717
How to approach GROUP BY in PostgreSQL using Rails?
65215
mysql select from n last rows
143982
How to extract the last inserted row in SQL Server?
62487
How to get the latest 2 items per category in one select (with mysql)