Fetching the latest N items by foreign key
86687
Django: How to select a limited amount of rows for each foreign key?
144830
How to select the most recent set of dated records from a mysql table
6011
How do I build a SOQL query for records in a list of IDs?
52984
How can I better optimize my tables and a LEFT JOIN query to find items that don't yet exist in the right table?
689
Using LIMIT within GROUP BY to get N results per group?
78159
Struggling to create an efficient index for this query
72586
MySQL: Fastest way to count number of rows
135135
Mysql selecting (n) rows of each occurrance
127084
Returning the 'last' row of each 'group by' in MySQL
17434
Get rows with most recent date for each different item
27636
Query to list number of records in each table in a database
115581
Get latest timestamp from column in given table dynamically
4994
Retrieving n rows per group
87556
How can I list all foreign keys referencing a given table in SQL Server?
112483
PostgreSQL, SELECT from max id
49911
How can I return 10 of the most recent results in sql?
2485
How to SELECT the newest four items per category?