Question

Which of the following is NOT an aggregate function in SQL?

Options

• MIN()

• SUM()

• UPPER()

• AVG()

Answer 1

UPPER()

Explanation:

UPPER() is not an aggregate function; it is a string function used to convert text to uppercase. Aggregate functions like MIN(), SUM(), and AVG() perform calculations on a set of values and return a single result, while UPPER() operates on individual string values.