Question 26Asked in UGC NET Computer Science, November 2017 (Paper II & III, Selected Questions)

In SQL ______is an Aggregate function.

  1. ASELECT
  2. BCREATE
  3. CAVG
  4. DMODIFY
Show answerHide answer

Correct answer: (C) AVG

Explanation

AVG returns the average of the values in a group, ignoring null values. It is an aggregate function. Syntax: AVG([ALL | DISTINCT] expression).

From UGC NET Computer Science PYQ, November 2017 (Paper II & III, Selected Questions)

This is question 26 of UGC NET Computer Science PYQ, November 2017 (Paper II & III, Selected Questions). 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.