Question 171Asked in DSSSB TGT Computer Science, 7 Feb 2024, Shift 2 (12:30 PM)

Which of the following is NOT an aggregate function in SQL?

  1. ACROSS PRODUCT
  2. BMAXIMUM
  3. CCOUNT
  4. DSUM
Show answerHide answer

Correct answer: (A) CROSS PRODUCT

Explanation

SQL aggregate functions include COUNT, SUM, AVG, MAX and MIN. Cross product is a relational join operation, not an aggregate.

From DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 PM)

This is question 171 of DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 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.