数字

加法。

SELECT 1 + 2 AS result;

result
3

SELECT 0.1 + 0.2 AS result;

result
0.3

减法。

SELECT 7 - 2 AS result;

result
5

SELECT 0.7 - 0.2 AS result;

result
0.5

乘法。

SELECT 3 * 4 AS result;

result
12

SELECT 0.3 * 0.4 AS result;

result
0.12

除法。

SELECT 8 / 2 AS result;

result
4.0000

SELECT 7 / 2 AS result;

result
3.5000

向下取整。

SELECT FLOOR(8 / 2) AS result;

result
4

SELECT FLOOR(7 / 2) AS result;

result
3

向上取整。

SELECT CEIL(8 / 2) AS result;

result
4

SELECT CEIL(7 / 2) AS result;

result
4

舍入。

SELECT ROUND(8 / 2) AS result;

result
4

SELECT ROUND(7 / 2) AS result;

result
4

SELECT ROUND(5 / 2) AS result;

result
3

取余。

SELECT 8 % 2 AS result;

result
0

SELECT 7 % 2 AS result;

result
1