Question 158

Which SQL clause is used to filter groups formed by GROUP BY?

  1. AWHERE
  2. BHAVING
  3. CORDER BY
  4. DDISTINCT
Show answerHide answer

Correct answer: (B) HAVING

Explanation

WHERE filters rows; HAVING filters groups.

From DSSSB TGT Computer Science Full Mock Test 1

This is question 158 of DSSSB TGT Computer Science Full Mock Test 1. 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.