Three table query to find the most recent item based on a distinct value
4994
Retrieving n rows per group
138700
Returning records from the last 3 months only in MySQL
83264
Get Max value and corresponding column
12037
Remove duplicate values from query result
138361
What's faster, SELECT DISTINCT or GROUP BY in MySQL?
90580
Select record when third column matches certain criterion
67770
MySQL: Count the distinct rows per day
19952
Counting DISTINCT over multiple columns
17323
Selecting most recent date between two columns
85400
How to get the count of each distinct value in a column?
144830
How to select the most recent set of dated records from a mysql table
16123
How to find rows that have maximum value?
80391
T-SQL: Selecting Column Based on MAX(Other Column)
21478
sql query to return differences between two tables
145393
Filter query result by most recent date
18269
SQL MAX of multiple columns?
78728
Finding duplicate values in a SQL table