SQL

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

How to round the numbers in SQL language

4.2 --> 4
4.7 --> 5
4.5 --> 5
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding numbers in SQL 1
Need a formula for a descimal integer into a whole number 1
Ryzen 7 2700x or Ryzen 5 5800x 1
I need help on SQL 0
Rounding numbers in a cell with a funtion 1
Windows 10 How do I stop Windows automatically adding a space after punctuation 3
stepping chart 2
Install framework 4.5 5

Back
Top