Home » MCQs » SQL MCQs » SQL Statements and Clauses MCQs

Which one is not the OPTIONAL Clause in SELECT statement?

1. Which one is not the OPTIONAL Clause in SELECT statement?

1. WHERE
2. ORDER BY
3. HAVE
4. HAVING

Answer: C) HAVE

Explanation:

WHERE, ORDER BY and HAVING are all OPTIONAL Clauses in SELECT statement.