Selecting unique rows based on the maximum date
42491
How do I efficiently get "the most recent corresponding row"?
130531
SELECT DISTINCT on multiple columns
36815
SQL: how to select a single id ("row") that meets multiple criteria from a single column
112312
Create unique sequence per set of rows sharing the same foreign key value
37727
How to randomly select rows in SQL?
93927
Display Top X results for each unique value
6884
Select values that meet different conditions on different rows?
16710
Filtering the line with the largest value for a given ID
98172
Better way for users to select a date range
62624
What is a simple and efficient way to find rows with time-interval overlaps in SQL?
155343
Select multiple (non-aggregate function) columns with GROUP BY
102471
SQL: Get records created in time range for specific dates
141135
MySQL - maximum of sum over different months with ties over multiple years
127084
Returning the 'last' row of each 'group by' in MySQL
53689
Filtering out duplicated/non-unique rows in data.table
109259
mysql select distinct rows into a comma delimited list column
67770
MySQL: Count the distinct rows per day