SQL queries to select first or last set of rows
April 27, 2022
- select last 100 rows
SELECT * FROM database.table
ORDER BY id DESC LIMIT 100- select first 100 rows
SELECT * FROM database.table
ORDER BY id ASC LIMIT 100April 27, 2022
SELECT * FROM database.table
ORDER BY id DESC LIMIT 100SELECT * FROM database.table
ORDER BY id ASC LIMIT 100