Question 3Asked in Bihar STET 2025 Paper II Computer Science, 3 Nov 2025, Shift 2 (2:00 PM)

Aggregate functions can be used with………….clause. They can not be used with………

Aggregate functions can be used with………….clause. They can not be used with……… clause.
  1. AWHERE, HAVING
  2. BHAVING, WHERE
  3. CGROUP BY, HAVING
  4. DSELECT, HAVING
Show answerHide answer

Correct answer: (B) HAVING, WHERE

Explanation

Aggregate functions such as SUM or COUNT can be used in the HAVING clause, which filters groups after grouping, but not in WHERE, which filters individual rows before any aggregation happens.

From Bihar STET 2025 Paper II Computer Science PYQ, 3 Nov 2025, Shift 2 (2:00 PM)

This is question 3 of Bihar STET 2025 Paper II Computer Science PYQ, 3 Nov 2025, Shift 2 (2:00 PM). 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.