足算/引算/掛算/割算
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 |