SQL ROUND

ROUND function is used to round a numeric field in a number of digits.

SQL Syntax ROUND

SELECT ROUND (column, decimals) FROM table

Example SQL ROUND

Given the following table 'orders'

idorderclientprice
1p1HARRY100.25
2p2CLARK305.57
3p3BROWN250.84

If you want the order prices without decimal numbers, run:

SELECT ROUND(price,0) AS rprice
FROM orders

The result will be:

rprecio
100
306
251