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 / SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
- B.
SELECT, WHERE, FROM, GROUP BY, HAVING, ORDER BY / SELECT, WHERE, FROM, GROUP BY, HAVING, ORDER BY
- C.
SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY / SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY
- D.
SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING / SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING
Attempted by 1185 students.
Show answer & explanation
Correct answer: A
The correct sequence of clauses in an SQL SELECT query is: SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY This is the standard order in which SQL processes a query. Option A matches this correct sequence. Hindi Explanation: SQL SELECT