SQL select only rows with max value on a column
7064
Retrieving the last record in each group - MySQL
108056
Returning a result set with multiple rows based on max date
47514
How can I select rows from a hierarchical query with the lowest level?
69351
Selecting random rows with MySQL
44049
How can I find last row that contains data in a specific column?
121572
How to get the maximum value by group
93921
Select groups based on number of unique / distinct values
16740
SQL Selecting "Window" Around Particular Row
8196
How to read the last row with SQL Server
22985
SQL query that gives distinct results that match multiple columns
86298
How do I (or can I) SELECT DISTINCT on multiple columns?
118038
Varchar data shows results selectively
80391
T-SQL: Selecting Column Based on MAX(Other Column)
98152
SQL Convert column to row
35430
selecting where two columns are in a set
15594
Select the row with the maximum value in each group
109259
mysql select distinct rows into a comma delimited list column