UTpaper

Free mock tests & test series

Question 68Asked in BPSC TRE 1.0 (2023) Computer Science Class 11-12

Which of the following is true about the HAVING clause?

  1. ASimilar to the WHERE clause but is used for columns rather than groups
  2. BSimilar to WHERE clause but is used for rows rather than columns
  3. CSimilar to WHERE clause but is used for groups rather than rows
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (C) Similar to WHERE clause but is used for groups rather than rows

Explanation

HAVING filters groups made by GROUP BY, while WHERE filters individual rows before they are grouped.

From BPSC TRE 1.0 (2023) Computer Science Class 11-12 — Previous Year Paper

This is question 68 of BPSC TRE 1.0 (2023) Computer Science Class 11-12 — Previous Year Paper. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.