Question

How to use SQL ROUND() Function in MySQL

Answer 1

SELECT ROUND(Price, 0) AS RoundedPrice 
FROM workers

--  RoundedPrice    
--    3000 -- from 3000.45
--    6001 -- from 6000.55
--    7000 -- from 7000

 

70+ SQL courses for beginners and professionals

Answer 2

SELECT ROUND(Price, 1) AS RoundedPrice 
FROM workers

--  RoundedPrice    
--    3000.4
--    6000.5
--    7000.0

 

70+ SQL courses for beginners and professionals

Answer 3

SELECT ROUND(Price, 2) AS RoundedPrice
FROM workers

--  RoundedPrice 	
--    3000.45
--    6000.55
--    7000.00

 

70+ SQL courses for beginners and professionals