Question

Write the output of the following SQL queries.

(0 SELECT ROUND (8.687,2)

(ii) SELECT DAYOFMONTH ('2016-08-20')

(iii) SELECT MONTH ('2016-03-20')

(iv) SELECT RIGHT (COMPUTER', 4)

Answer 1

(i) 8.69

(ii) 20

(iii) 03

(iv) UTER