How to select latest record in a group?
2789
Fetch the row which has the Max value for a column
2241
Get top 1 row of each group
95678
MYSQL: How to select all attributes of all duplicate entries?
118546
In SQL, how can you "group by" in ranges?
75982
How To Group Records By Value In A Specific Field?
155343
Select multiple (non-aggregate function) columns with GROUP BY
116962
How to select last N records from a table in mysql
42014
Compare records value with each others
113286
Get top n records for each group of grouped results
60950
How to group by DESC order
32395
How do I remove duplicate records in a join table in PostgreSQL?
780
How group with min(date) and select an another column in the same table
110439
How to get first record in each group using Linq
90459
Select top 10 records for each category
88569
Increment value based on grouped field
156237
Efficient query to get greatest value per group from big table
34917
Selecting through one-to-many relationship