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;

Question

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.

Answer 1

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}\]

List-I	List-II
(A) SUBSTR()	(II) To extract a substring from a string.
(B) TRIM()	(IV) To remove spaces from both sides of the string.
(C) INSTR()	(I) To find the position of a substring in a string.
(D) LEFT()	(III) To extract characters from the left side of the string.

List-I (Aggregate function)	List-II (Description)
(A) `count(marks)`	(III) Count all non null values of marks column
(B) `count()`	(I) Count all rows
(C) `avg(marks)`	(II) Finding average of non null values of marks
(D) `sum(marks)`	(IV) Finding sum of all marks

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

The Correct Option is C

Solution and Explanation

Top Questions on SQL

Questions Asked in CUET (UG) exam

Given the following table:ENOSALARYA1014000B109NULLC5086000A3052000State the output of the following query: SELECT COUNT(SALARY) FROM EMPLOYEE;

Show Hint

The Correct Option is C

Solution and Explanation

Top Questions on SQL

Questions Asked in CUET (UG) exam

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;