SELECT TOP 20 rows for each group
90459
Select top 10 records for each category
85421
How to SELECT random rows from table with an exact number of row?
11591
Manipulate results to display rows as columns
13678
'SELECT TOP' performance question
66956
Get most common value for each value of another column in SQL
47514
How can I select rows from a hierarchical query with the lowest level?
81132
MySQL pivot row into dynamic number of columns
43786
SQL group by day, show orders for each day
93921
Select groups based on number of unique / distinct values
86687
Django: How to select a limited amount of rows for each foreign key?
155343
Select multiple (non-aggregate function) columns with GROUP BY
7064
Retrieving the last record in each group - MySQL
39628
SQL select only rows with max value on a column
155396
Selecting multiple rows by given amount of volume
84927
Get names of column with max value for each row
124091
Showing only the top 5 results
144830
How to select the most recent set of dated records from a mysql table