Question

A numeric data field AMOUNT store a value 205.98. Round it *** using MySQL to :

(i) Upto 1 decimal place

(ii) to a whole number.

Answer 1

(i) SELECT ROUND (AMOUNT 1)

(ii) SELECT ROUND (AMOUNT,0)