English

Which aggregate function in SQL displays the number of values in the specified column ignoring the NULL values? - Computer Science (Python)

Advertisements
Advertisements

Question

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

Options

  • len()

  • count()

  • number()

  • num()

MCQ
Advertisements

Solution

count()

Explanation:

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

shaalaa.com
  Is there an error in this question or solution?
2024-2025 (March) Set 4
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×