Return row with the max value of one column per group
2789
Fetch the row which has the Max value for a column
86298
How do I (or can I) SELECT DISTINCT on multiple columns?
46441
Combine column from multiple rows into single row
39628
SQL select only rows with max value on a column
79081
Table with actions per row
6884
Select values that meet different conditions on different rows?
75982
How To Group Records By Value In A Specific Field?
31013
How to select records with maximum values in two columns?
39758
Collapse / concatenate / aggregate a column to a single comma separated string within each group
137984
How do I use "GROUP BY"?
24927
Use column alias in GROUP BY
93921
Select groups based on number of unique / distinct values
79634
find the min and max value in two columns
93927
Display Top X results for each unique value
100981
Select multiple rows with different criteria for each
65917
Combine multiple results in a subquery into a single comma-separated value
17434
Get rows with most recent date for each different item