UTpaper

Free mock tests & test series

Question 131Asked in BPSC TRE 2.0 (2023) Computer Class 9-10

After groups have been established, SQL applies predicates in the _____ clause, allowing aggregate functions to be used.

  1. AHAVING
  2. BGROUP BY
  3. CWITH
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (A) HAVING

Explanation

The HAVING clause filters groups after GROUP BY and may use aggregate functions.

From BPSC TRE 2.0 (2023) Computer Class 9-10 — Previous Year Paper

This is question 131 of BPSC TRE 2.0 (2023) Computer Class 9-10 — 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.