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'

Also consider CAST(population/1000000 AS decimal(8,2))

Also consider CAST(population/1000000 AS decimal(8,2))

SELECT title, score, FORMAT(score,2)
 FROM movie

WHERE id <= 10

Functions

Concatenate strings

Extracting substrings

lower case

Finding Substring

Formatting numbers

Replace NULL

Conditional values

Time now

Format dates