Learn SQL
LIMIT with ordering and offset
24.1
Lesson

Select top 10 students with highest marks

Find first 10 students with highest marks from the students table.

We can order students by their marks using ORDER BY. We can pick the top 10 students by adding LIMIT to ORDER BY.