COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is a SQL aggregate function?
|
|
LEFT
|
|
|
LEN
|
|
|
AVG
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -An aggregate function in SQL performs a calculation on multiple values and returns a single value. SQL provides many aggregate functions that include avg, count, sum, min, max, etc. An aggregate function ignores NULL values when it performs the calculation, except for the count function.
Detailed explanation-2: -COUNT, SUM, and MAX are all aggregate functions.
Detailed explanation-3: -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.
There is 1 question to complete.