If you want to round a decimal number using SQL, use the ROUND() function of SQL.
Syntax:

SELECT ROUND(column_name,decimals) FROM table_name

eg:

SELECT itemName, ROUND(Price,2) as Price FROM Purchase

It will select itemName and Price from the table ‘Purchase’ and will Round the Price with 2 decimal places.

🙂

 

Leave a Reply

Your email address will not be published. Required fields are marked *

 

 

 

Theme by HermesThemes

Copyright © 2018 CoderzHeaven. All Rights Reserved

Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.