Give the output of the query: SELECT MONTH("2010-03-05");
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;
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. |