| 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;