Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024SQL
|
Question 152
|
Aggregate functions in SQL are :
|
GREATEST, LEAST and ABS
|
|
|
SUM, COUNT and AVG
|
|
|
UPPER, LOWER and LENGTH
|
|
|
SQRT, POWER and MOD
|
Question 152 Explanation:
Aggregate functions in SQL are SUM,COUNT,AVG,MIN and MAX.
The COUNT() function returns the number of rows that matches a specified criteria.
The AVG() function returns the average value of a numeric column.
The SUM() function returns the total sum of a numeric column.
The COUNT() function returns the number of rows that matches a specified criteria.
The AVG() function returns the average value of a numeric column.
The SUM() function returns the total sum of a numeric column.
Correct Answer: B
Question 152 Explanation:
Aggregate functions in SQL are SUM,COUNT,AVG,MIN and MAX.
The COUNT() function returns the number of rows that matches a specified criteria.
The AVG() function returns the average value of a numeric column.
The SUM() function returns the total sum of a numeric column.
The COUNT() function returns the number of rows that matches a specified criteria.
The AVG() function returns the average value of a numeric column.
The SUM() function returns the total sum of a numeric column.