Question · SQL and MySQL course · Module 2: Querying data (SELECT)

How LIMIT with OFFSET works

What will the clause LIMIT 5 OFFSET 10 return (with a fixed sort order)?

Answer options

  • It returns the first 10 rows
  • It returns rows from 5 to 10
  • It skips 10 rows and returns the next 5 (positions 11-15)
  • It returns exactly the last 15 rows
Show the answer

Correct answer:

  • It skips 10 rows and returns the next 5 (positions 11-15)