SQL round()

ROUND() function is used to round a numeric column.It returns only specified number of decimals.


SYNTAX :
ROUND(column_name,decimals)

Table Name 'customers'

id

name

age

city

bill

1Tom34Paris5300
2Jhony51London 400
3Ram64Delhi20000.7
4Simon23Portland32.65



Online Execute/Compile

Quantitative Aptitude
Reasoning
Programming
Interview