Question:
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
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
Step 1: Understanding COUNT(column).
The SQL \texttt{COUNT(column)} function counts only the non-NULL values in a column.
Step 2: Identify non-NULL salaries.
From the table: Salaries = 4000, NULL, 6000, 2000.
Valid non-NULL values = 3.
Step 3: Output.
\[ \text{COUNT(SALARY)} = 3 \]
Final Answer: \[ \boxed{3} \]
The SQL \texttt{COUNT(column)} function counts only the non-NULL values in a column.
Step 2: Identify non-NULL salaries.
From the table: Salaries = 4000, NULL, 6000, 2000.
Valid non-NULL values = 3.
Step 3: Output.
\[ \text{COUNT(SALARY)} = 3 \]
Final Answer: \[ \boxed{3} \]
Was this answer helpful?
0
0
Top CUET Computer Science Questions
- Which one of the following is not a built-in-exception in Python?
- The following five statements describe the methods used for file handling in Python. Choose an option that correctly sequences the definition of each.
(A) Method used to open a file.
(B) Method used to write the objects in a binary file.
(C) Method used to read data from a binary file.
(D) Method used to return an integer that specifies current position of the file object.
(E) Method used to position the file object at a particular position in a file.
Choose the correct answer from the options given below: - While opening a text file, the text editor translates :
- In Python, when open() method is applied in ‘<a>' mode, a file is opened in append mode. If the file does not exist, then :
- A table student has two text fields defined as below:
Name_1 varchar(20),
Name2 char(20)
If Name_1 stores value as ‘Ana' and Name2 stores value as ‘Anuj', then Name_1 will consume characters space and Name2 will consume characters space.
View More Questions
Top CUET SQL Questions
- A __________ value is specified for the column, if no value is provided.
- Given table 'StudAtt' with structure as (Rno, Attdate, Attendance). Identify the suitable command to add a primary key to the table after creation.
Note: We want to make both Rno and Attdate columns as primary key. - The SELECT command when combined with DISTINCT clause is used to:
- ____________________________________ is used to search for a specific pattern in a column.
Give the output of the query: SELECT MONTH("2010-03-05");
View More Questions
Top CUET Questions
Select the statements that are CORRECT regarding patterns of biodiversity.
(A) Species diversity increases as we move away from the equator towards the poles(B) The tropical Amazon rain forest in South America has the greatest biodiversity on earth.(C) There is more solar energy available in the temperate region than tropics.(D) Tropical environments are less seasonal relatively more constant and predictableWhich of the following hormone is not produced by placenta ?
- Individuals with karyotype of 44+XXY having overall masculine development with few feminine development like Gynaecomastia has _______ chromosomal disorder.
- Match List - I with List - II.Choose the correct answer from the options given below :
List - I
List - II
A Streptokinase I Blood-Cholestrol lowering agents B Cyclosporin II Clot Buster C Statins III Propionibacterium sharmanii D Swiss Cheese IV Immuno suppressive agent Which of the following option determines percolation and water holding capacity of soils ?
View More Questions