Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 34 of 90

Querying Using SQL — Question 12

Back to all questions
12
Question

Question 12

The HAVING clause does which of the following ?

  1. Acts EXACTLY like a WHERE clause.
  2. Acts like a WHERE clause but is used for columns rather than groups.
  3. Acts like a WHERE clause but is used for groups rather than rows.
  4. Acts like a WHERE clause but is used for rows rather than columns.
Answer

Acts like a WHERE clause but is used for groups rather than rows.

Reason — The HAVING clause places conditions on groups in contrast to WHERE clause that places conditions on individual rows.