SQL Server Note

足算/引算/掛算/割算

SELECT POINT,
POINT + 2 AS [ADDITION],
POINT - 2 AS [SUBTRACTION],
POINT * 2 AS [MULTIPLICATION],
POINT / 2 AS [DIVISION]
FROM CUSTOMER
POINTADDITIONSUBTRACTIONMULTIPLICATIONDIVISION
5.67.63.611.22.800000
3.55.51.57.01.750000
4.06.02.08.02.000000
NULLNULLNULLNULLNULL
8.210.26.216.44.100000
Copyright © 2006 Hikijishi All Rights Reserved.
[] [sql][0.00102591514587402]