SQL- Scalar Functions- ROUND()

nThe ROUND() function is used to round a numeric field to the number of decimals specified.

Syntax:

SELECT Round(column_name,decimals) FROM table_name

Query:

SELECT ROUND(Unitprice,0) AS PRODUCT PRICE FROM ORDtbl