Which aggregate function in SQL displays the number of values in the specified…
2026
Which aggregate function in SQL displays the number of values in the specified column ignoring the NULL values?
- A.
len ( )
- B.
count ( )
- C.
number ( )
- D.
num ( )
Attempted by 1234 students.
Show answer & explanation
Correct answer: B
Correct Answer: count() The correct aggregate function in SQL that displays the number of values in a specified column while ignoring NULL values is count(). This function counts only the non-NULL entries in the column.