Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 24 of 91

Grouping Records, Joins in SQL — Question 2

Back to all questions
2
Question

Question 2

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.