Returning only 1 row that meets some criteria
4994
Retrieving n rows per group
77455
Only inserting a row if it's not already there
21641
Remove duplicate entries, keeping latest only
155290
Subquery Returned More Than 1 Value with the Group By
124005
How to query records having at least one valid child record?
143452
PostgreSQL - fetch the row which has the Max value for a column
105883
Inserting multiple rows in a single SQL query?
24120
Return a column per date in a range
17186
How to get only the unique results without having to sort data?
38470
Subquery returns more than 1 row SQL
99373
SQL server select distinct rows using most recent value only
50422
Can't list users - "select * from user" returns only one row with one column
31013
How to select records with maximum values in two columns?
98420
Why does this query only show one result?
62313
single query to print all the rows whose count is greater than 10
100981
Select multiple rows with different criteria for each
153827
Why the rows returns by "explain" is not equal to count()?