01

Using the table from this section, We can 'limit' the results shown with LIMIT

SELECT student_id, name
FROM student
LIMIT 2;

This will only show the first 2 rows

02

This will order the students by name with the student_id's in decending order, displaying only the first 3 results

SELECT *
FROM student
ORDER BY name, student_id DESC
LIMIT 3;