Question

Which aggregate function in SQL displays the number of values in the specified column ignoring the NULL values?

Options

• len()

• count()

• number()

• num()

Answer 1

count()

Explanation:

The count() is an aggregate function that counts the number of non-NULL values in a column.