Which of the following is NOT an aggregate function?

Answer: Select

An aggregate function performs a calculation on a set of values, and returns a single value.

In database management, an aggregate function or aggregation function takes values of multiple rows in a single column are processed together to form a single value.

Common aggregate functions include:

• Average (avg)
• Count
• Maximum (max)
• Median
• Minimum (min)
• Mode
• Range
• Sum

SELECT query is used to retrieve data from a table. It is the most used SQL query.

A SELECT statement retrieves zero or more rows from one or more database tables or database views.