Which of the following is correct sequence in a SELECT query ?
2023
Which of the following is correct sequence in a SELECT query ?
- A.
SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
- B.
SELECT, WHERE, FROM, GROUP BY, HAVING, ORDER BY
- C.
SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY
- D.
SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING
Attempted by 1683 students.
Show answer & explanation
Correct answer: A
Correct sequence: SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY FROM — specifies the source table(s) for the query.
A video solution is available for this question — log in and enroll to watch it.