COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
which of the following is not an aggregate function in SQL?
|
|
SUM
|
|
|
AVG
|
|
|
COUNT
|
|
|
FIND
|
Explanation:
Detailed explanation-1: -COUNT, SUM, and MAX are all aggregate functions. COMPUTE is not an aggregate function.
Detailed explanation-2: -Which of the following is not a built in aggregate function in SQL? Explanation: SQL does not include total as a built in aggregate function. The avg is used to find average, max is used to find the maximum and the count is used to count the number of values. 2.
Detailed explanation-3: -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-4: -SQL provides many aggregate functions that include avg, count, sum, min, max, etc.
There is 1 question to complete.