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

Question 60 of 95

Q. 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()

Puducherry TnboardCBSE Class XII Board 2025MCQ· 1mImportance★★★★★

63% · 60/95 Questions

🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

Concept understanding — SQL Aggregate Functions

Imagine you have a giant box of receipts from a month of sales at a small shop. You don't want to look at every single receipt one by one — you want a single, useful number that summarises the whole pile. How much total money came in? What was the average sale? How many customers bought something? That instinct — to collapse a pile of raw details into one meaningful number — is exactly what an SQL aggregate function does.

In a database, a table might hold thousands of rows of data: one row for every sale, every student, every product. An aggregate function takes all those rows in a column and boils them down to a single value. It doesn't change the data; it answers a question about the whole set. The most common ones are COUNT, SUM, AVG, MIN, and MAX. Each one has a clear, everyday meaning.

COUNT tells you how many rows there are — like counting how many students are in a class list. SUM adds up all the numbers in a column — like totalling the marks of every student in an exam. AVG gives the average of those numbers. MIN and MAX find the smallest and largest values — the lowest temperature recorded or the highest sale of the day.

Note

Aggregate functions work on a column of data, not across rows. You always write them as FUNCTION_NAME(column_name). For example, AVG(price) gives the average of all prices in that column.

The real power comes when you combine them with the GROUP BY clause. Without GROUP BY, an aggregate function summarises the entire table. With GROUP BY, you split the table into groups first, then apply the function to each group separately. Think of it like this: you don't just want the average sale for the whole year — you want the average sale per month. GROUP BY month creates twelve groups, and AVG(sale_amount) runs once for each group, giving you twelve averages.

This is why aggregate functions matter in business, economics, and any data-driven decision. A manager doesn't ask "what was every single transaction?" They ask "what was the total revenue last quarter?" or "which product category had the highest average rating?" Aggregate functions turn raw, overwhelming data into actionable summaries. …

Start your 14-day free trial to unlock the full solution →

SQL aggregate functions are used to perform calculations on a set of rows and return a single summary value. Among the given options, the COUNT() function is the standard SQL aggregate function that serves this purpose.

When COUNT(column_name) is used, it specifically counts the number of non-NULL values in the specified column. This behavior ensures that any row containing a NULL value in that particular column is excluded from the count. The other options, len(), number(), an …

Start your 14-day free trial to unlock the full solution →

The COUNT() aggregate function in SQL is used to display the number of values in a specified column, inherently ignoring NULL values.

In SQL, aggregate functions are powerful tools designed to perform calculations on a set of rows and return a single summary value. These functions are fundamental for data analysis, allowing us to derive insights like sums, averages, maximums, minimums, and counts from large datasets. When dealing with real-world data, it's common to encounter NULL values, which represent missing or unknown data. How these NULL values are handled by aggregate functions is a crucial aspect of understanding their behavior.

The question specifically asks for an aggregate function that counts the number of values in a column while ignoring NULL entries. Among the standard SQL aggregate functions, COUNT() is precisely designed for this purpose.

Let's break down how COUNT() works:

COUNT(column_name): When you specify a column name inside the COUNT() function, like COUNT(EmployeeID) or COUNT(ProductName), SQL will iterate through each row in that column. For every row where the specified column_name has a non-NULL value, it increments the count. Rows where the column_name is NULL are simply skipped and do not contribute to the total count. This is the exact behavior requested by the question.
COUNT(*): It's important to distinguish COUNT(column_name) from COUNT(*). The COUNT(*) function counts the total number of rows in the result set, regardless of whether any specific column in those rows contains NULL values. It essentially counts the rows themselves, not the non-NULL values within a particular column.

Important

COUNT(column_name) counts only non-NULL values in the specified column, whereas COUNT(*) counts all rows, irrespective of NULLs in any column.

Now, let's consider the other options provided: …

Start your 14-day free trial to unlock the full solution →

←Previous questionQ2 — Which of the following is a DML command in SQL ? (A) UPDATE (B) CREATE…→Next questionQ4 — In MYSQL, which type of value should not be enclosed within quotation …

Q.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()

🎓Unlock everything free for 14 days

Unlock everything free for 14 days