LIMIT with Filters
Combine WHERE and LIMIT.
sql
1SELECT * FROM students
2WHERE course IN ('Python', 'Ruby')
3LIMIT 4;Returns first 4 Python or Ruby students.
Order of Clauses
sql
1SELECT columns
2FROM table
3WHERE condition
4ORDER BY column
5LIMIT n;