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)