Question · SQL and MySQL course · Module 2: Querying data (SELECT)
Position of LIMIT in a query
Where in a query do we place the LIMIT clause?
Answer options
- Right after SELECT, before the column names
- Before the word FROM
- Directly after FROM, before ORDER BY
- At the very end of the query, after ORDER BY
Show the answer
Correct answer:
- At the very end of the query, after ORDER BY