Home » MCQs » Oracle MCQs » Oracle Clauses MCQs

By using the _____ clause with the GROUP BY Clause in Oracle, the condition TRUE is used to limit the rows returned which are grouped into groups

11. By using the _____ clause with the GROUP BY Clause in Oracle, the condition TRUE is used to limit the rows returned which are grouped into groups.

1. HAVE
2. HAVIN
3. HAVING
4. None

Answer: C) HAVING

Explanation:

By using the HAVING clause with the GROUP BY Clause in Oracle, the condition TRUE is used to limit the rows returned which are grouped into groups.