siva nathan

siva nathan

  • 953
  • 828
  • 233.2k

how to round of in sql

Apr 18 2017 7:30 AM
I have a table column values like below
Hours
1.3000
0.4500
3.4500
2.4000
my expected result is
Hours
2
1
4
3
how to achieve this output without using ceiling because ceiling convert 1.10  as 2 .my case is whenever the value is like  .30 or 1.30 means convert 1 and 2 how to get this

Answers (10)