OFFSET Clause
OFFSET skips rows before returning results.
Syntax
sql
1SELECT * FROM students
2LIMIT 5 OFFSET 5;Skips first 5, returns next 5 (rows 6-10).
Example: Ranks 6-10
sql
1SELECT name, marks FROM students
2ORDER BY marks DESC
3LIMIT 5 OFFSET 5;Top scorers ranked 6th to 10th.
Alternative Syntax
sql
1-- LIMIT offset, count
2SELECT * FROM students LIMIT 5, 5;