Question

Which of the following is not a valid aggregate function in MYSQL? 

Options

• COUNT()

• SUM()

• MAX()

• LEN()

Answer 1

LEN()

Explanation:

While aggregate methods operate on several rows in a table, SQL's LEN() function returns the length of a string.