Question

Write the output of the following SQL queries.

(i) SELECT ROUND (6.5675,2);

(ii) SELECT TRUNCATE (5.3456,1);

(iii) SELECT DAYOFMONTH ('2016-08-25');

(iv) SELECT MID ('Computer', 2, 3);

Answer 1

(i) 6.57

(ii) 5.3

(iii) 25

(iv) omp