Informatics Practices
Which of the following are correct aggregate functions in SQL ?
- AVERAGE()
- MAX()
- COUNT()
- TOTAL()
SQL Queries
2 Likes
Answer
MAX(), COUNT()
Reason — Aggregate functions in SQL include AVG(), COUNT(), MAX(), MIN(), and SUM().
Answered By
2 Likes
Related Questions
What will returned by the given query ?
SELECT Truncate(15.79, -1), Truncate(15.79, 0), Truncate(15.79, 1);- 15 15 15.7
- 10 15.7 15.9
- 10 15 15.7
- 10 10 15.9
What will be returned by the given query ?
SELECT month('2020-05-11');- 5
- 11
- May
- November
Write the output of the following SQL command :
SELECT Round(49.88);- 49.88
- 49.8
- 49.0
- 50
Predict the output of the following query :
SELECT MOD(9, 0);- 0
- NULL
- NaN
- 9