Question · SQL and MySQL course · Module 2: Querying data (SELECT)

Order of clauses in a query

What is the correct order of clauses in an extended SELECT query?

Answer options

  • SELECT -> FROM -> ORDER BY -> LIMIT
  • FROM -> SELECT -> LIMIT -> ORDER BY
  • SELECT -> ORDER BY -> FROM -> LIMIT
  • LIMIT -> SELECT -> FROM -> ORDER BY
Show the answer

Correct answer:

  • SELECT -> FROM -> ORDER BY -> LIMIT