SQL query by date...

MySQL find top results for each group...

Get highest value for each group of names...

T-SQL select rows by oldest date and unique category...

How do I select last message for each conversation?...

Limiting the number of rows returned from an inner join...

Get last action of a person on a specific date...

select rows satisfying some criteria and with maximum value in a certain column...

SQL - Query control record chosen by group by...

sql server: indexed view containing greatest row per group...

Grouping data, later getting extra fields...

Getting Distinct Max Values from Multiple Columns...

Finding the max temperature for a given day in SQL...

MySQL - combining multiple queries...

How do I get a record from the most recent archive table that an ID occurs in...

SQL: return row with maximum value per group...

What is the best way to select the first two records of each group by a "SELECT" command?...

How do I join 4 tables on mysql select statement?...

MySQL correlated subquery ordered by date&time...

Select multiple distinct rows from table SQL...

get Row with most likes per day...

Unable to convert SQL which is meant for greatest N per group to HQL...

SQL join left get MAX(date)...

Extract longest strings from sublist within list . Python...

get the last record in each group in MYSQL singular table, with criteria that ignores certain groups...

Getting last 6 records for each team in a MySQL database...

MySQL group by 2 columns, but return in specific order...

SQL Get rows based on max column...

MYSQL, Max,Group by and Max...

This self-left-join is returning more records than I expected it to...