SQL queries to select first or last set of rows

27-04-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 100