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.