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