Question

Write the output of the following SQL queries:

(i) SELECT INSTR('INTERNATIONAL','NA');

(ii) SELECT LENGTH(CONCAT('NETWORK' ,'ING'));

(iii) SELECT ROUND(563. 345,-2) ;

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

Answer 1

(i.) 6

(ii.) 10

(iii.) 600

(iv.) 30