足算/引算/掛算/割算
SELECT POINT,
POINT + 2 AS [ADDITION],
POINT - 2 AS [SUBTRACTION],
POINT * 2 AS [MULTIPLICATION],
POINT / 2 AS [DIVISION]
FROM CUSTOMER
POINT | ADDITION | SUBTRACTION | MULTIPLICATION | DIVISION |
---|---|---|---|---|
5.6 | 7.6 | 3.6 | 11.2 | 2.800000 |
3.5 | 5.5 | 1.5 | 7.0 | 1.750000 |
4.0 | 6.0 | 2.0 | 8.0 | 2.000000 |
NULL | NULL | NULL | NULL | NULL |
8.2 | 10.2 | 6.2 | 16.4 | 4.100000 |