Question

Write the output of the following SQL queries :

(i) SELECT MID ('VisitIndia',6,5);

(ii) SELECT ROUND(89.387,2);

(iii) SELECT INSTR (COMPUTER CLASS', 'PUT');

(iv) SELECT DAY OF MONTH ('2016-01-20');

Answer 1

(i) India

(ii) 89.39

(iii) 4

(iv) 20