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