Question:medium
Which aggregate function in SQL displays the number of values in the specified column ignoring the NULL values?
Which aggregate function in SQL displays the number of values in the specified column ignoring the NULL values?
Show Hint
Use
and
COUNT(*) to count all rows including NULLs,and
COUNT(column_name) to count only non-NULL entries.Updated On: Jan 14, 2026
- len()
- count()
- number()
- num()
Show Solution
The Correct Option is B
Solution and Explanation
In SQL, COUNT() is an aggregate function that determines the number of rows satisfying a given condition. When applied to a column, COUNT() specifically tallies non-NULL values, automatically disregarding any NULL entries. Functions such as len(), number(), and num() are not recognized as valid SQL aggregate functions. While len() is present in Python, it is not a SQL function. Consequently, COUNT() is the correct function for counting values while excluding NULLs. Thus, option (B) is correct.
Was this answer helpful?
0
Top Questions on SQL
Suman has created a table named WORKER with a set of records to maintain the data of the construction sites, which consists of WID, WNAME, WAGE, HOURS, TYPE, and SITEID. After creating the table, she entered data in it, which is as follows :
- While creating a table, which constraint does not allow insertion of duplicate values in the table?
- Which of the following is a DML command in SQL?
- In MYSQL, which type of value should not be enclosed within quotation marks?
- Want to practice more? Try solving extra ecology questions todayView All Questions