COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which is not an aggregate function?
|
SUM()
|
|
POW()
|
|
AVG()
|
|
COUNT()
|
Explanation:
Detailed explanation-1: -Which of the following is not an aggregate function? Explanation: With is used to create temporary relation and its not an aggregate function.
Detailed explanation-2: -The SQL SUM function is an aggregate function that is used to perform a calculation on a set of values from a specified expression and return a single value in their output.
Detailed explanation-3: -What Is an Aggregate Function? An aggregate function is a mathematical computation involving a range of values that results in just a single value expressing the significance of the accumulated data it is derived from. Aggregate functions are often used to derive descriptive statistics.
There is 1 question to complete.