Question:medium
Given the following table:
ENO SALARY A101 4000 B109 NULL C508 6000 A305 2000
State the output of the following query:
SELECT COUNT(SALARY) FROM EMPLOYEE;
Given the following table:
| ENO | SALARY |
|---|---|
| A101 | 4000 |
| B109 | NULL |
| C508 | 6000 |
| A305 | 2000 |
State the output of the following query:
SELECT COUNT(SALARY) FROM EMPLOYEE;
Show Hint
\texttt{COUNT()} counts all rows including NULLs, while \texttt{COUNT(column)} ignores NULL values.
Updated On: Feb 16, 2026
- 4
- 2
- 3
- 1
Show Solution
The Correct Option is C
Solution and Explanation
Step 1: Understanding COUNT(column).
The SQL \texttt{COUNT(column)} function enumerates the non-null entries within a specified column.
Step 2: Identify non-NULL salaries.
From the provided dataset: Salaries are 4000, NULL, 6000, and 2000.
The count of valid, non-NULL entries is 3.
Step 3: Output.
\[\text{COUNT(SALARY)} = 3\]
Final Answer: \[\boxed{3}\]
The SQL \texttt{COUNT(column)} function enumerates the non-null entries within a specified column.
Step 2: Identify non-NULL salaries.
From the provided dataset: Salaries are 4000, NULL, 6000, and 2000.
The count of valid, non-NULL entries is 3.
Step 3: Output.
\[\text{COUNT(SALARY)} = 3\]
Final Answer: \[\boxed{3}\]
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?
- Which aggregate function in SQL displays the number of values in the specified column ignoring the NULL values?
- Want to practice more? Try solving extra ecology questions todayView All Questions