Eine Einführung in
SQL
Formatting numbers to two decimal places.
SQLite
This rounds up or down
SELECT name, population, ROUND(population/1000000,2), ROUND(population,-6) FROM cia WHERE region='North America'
Specific to SQLite
none
DB2
This rounds up or down
SELECT name, population, ROUND(population/1000000,2), ROUND(population,-6) FROM cia WHERE region='North America'
Specific to DB2
none
MS Access
This rounds up or down
SELECT title, score, FORMAT(score,'.00') FROM movie WHERE id <= 10
Specific to MS Access
none
PostgreSQL
This rounds up or down
SELECT name, population, ROUND(population/1000000,2), ROUND(population,-6) FROM cia WHERE region='North America'
Specific to PostgreSQL
none
Oracle
This rounds up or down
SELECT name, population, ROUND(population/1000000,2), ROUND(population,-6) FROM cia WHERE region='North America'
Specific to Oracle
none
MS SQL Server
This rounds up or down
SELECT name, population, ROUND(population/1000000,2), ROUND(population,-6) FROM cia WHERE region='North America'
Specific to MS SQL Server
Also consider CAST(population/1000000 AS decimal(8,2))
MySQL
This rounds up or down
SELECT name, population, ROUND(population/1000000,2), ROUND(population,-6) FROM cia WHERE region='North America'
Specific to MySQL
Also:
SELECT title, score, FORMAT(score,2) FROM movie WHERE id <= 10
Sybase
This rounds up or down
SELECT name, population, ROUND(population/1000000,2), ROUND(population,-6) FROM cia WHERE region='North America'
Specific to Sybase
Also consider CAST(population/1000000 AS decimal(8,2))
Mimer SQL
This rounds up or down
SELECT name, population, ROUND(population/1000000,2), ROUND(population,-6) FROM cia WHERE region='North America'
Specific to Mimer SQL
none