SQL

[Mario]

How to round the numbers in SQL language

4.2 --> 4
4.7 --> 5
4.5 --> 5

 

[Keith]

Good question, Floor and Ceiling go up or down from O
always. The way to do this is to use the round function
as follows:

ROUND( 4.2 ,0)

Good luck.