MySQL: How to limit results to max value of another field?...

Distinct - which items are taken? The first or the last occurance?...

SQL query to find values based on selected date, but will find the latest value if there's no va...

Get the minimum non zero value across multiple columns...

Select latest product code...

Select unique records...

Get the latest version of the data and set it to version 0 and remove all other records, for each da...

MySQL - How to use GROUP BY / ORDER BY with "nested" dataset?...

How to use group by to get only one row...

PostgreSQL select daily max and corresponding hour of ocurrence...

MySQL query limit per join...

SQL Query to return last value from a number of tags...

MySQL - given multiple associations, how to get latest association for several records?...

SQL Max over multiple versions...

ZF 1 Mysql WHERE IN query...

Get the first (sorted) match of second table in SQL Server?...

Getting most recent record from table via self join...

Select oldest two records from group...

Timetravel view in MySQL...

How to get rows with max(of a column) when using group by...

SQL for message inbox...

How to Prioritize OR condition in mysql...

Select the lowest n values from a group...

Export cheapest price and corresponding quantity?...

Mysql LEFT JOIN -> Get latest topic id / topic title...

Select a row with least value of a column using where and group by...

MYSQL Select 5 records for the last 5 distinct records...

MySQL: Insert top N rows from each group into a table. Assume millions of groups...

SQL: cte bring back top result each category...

SQL get the row with highest amount created first...