Question

Write the output of the following SQL queries :

(i) SELECT MID('LeaningIsFan', 2,4);

(ii) SELECT ROUND(76.384,2);

(iii) SELECT INSTR('INFORMATTON FORM', 'RM');

(iv) SELECT DAYOFYEAR ( '2015-01-30');

Answer 1

(i) ear

(ii) 76.38

(iii) 5

(iv) 30