Formating numbers to two decimal spaces
Formatting numbers to two decimal places.
schema:gisq
This rounds up or down
SELECT title, score,
FORMAT(score,'.00')
FROM movie
WHERE id <= 10
SELECT name,
population,
ROUND(population/1000000,2),
ROUND(population,-6)
FROM bbc
WHERE region='North America'