Skip
Arish's avatar

105. Practice - OFFSET

Exercise: 6th Student

Get the 6th student in alphabetical order.

Solution

sql
1SELECT * FROM students
2ORDER BY name
3LIMIT 1 OFFSET 5;

Skips first 5, gets the 6th.