Informatics Practices
Which of the following is not a valid aggregate function in MYSQL ?
- COUNT()
- SUM()
- MAX()
- LEN()
SQL Queries
3 Likes
Answer
LEN()
Reason — Aggregate functions in SQL include AVG(), COUNT(), MAX(), MIN(), and SUM().
Answered By
1 Like
Related Questions
Which one of the following is not an aggregate function ?
- ROUND()
- SUM()
- COUNT()
- AVG()
Which of the following SQL functions does not belong to the Math functions category ?
- POWER()
- ROUND()
- LENGTH()
- MOD()
What will be printed by the given query ?
SELECT LENGTH("WINNER");- 7
- 6
- 8
- 9
What will be returned by the given query ?
SELECT INSTR("INDIA", "DI");- 2
- 3
- -2
- -3