Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 33 of 79

Database Query using SQL — Question 4

Back to all questions
4
Question

Question 4

Which clause is used in query to place the condition on groups in MySQL?

  1. WHERE
  2. HAVING
  3. GROUP BY
  4. Both (i) & (ii)
Answer

HAVING

Reason — The HAVING clause is used in SQL queries to place conditions on groups when using the GROUP BY clause.