sql 2列相减

SELECT isnull(A,0)-isnull(B,0) AS 结果 FROM 表  --sqlserver语法



SELECT nvl(A,0)-nvl(B,0) AS 结果 FROM 表  --Oracle语法



SELECT ifnull(A,0)-ifnull(B,0) AS 结果 FROM 表  --mysql语法



select abs(ifnull(a.stid,0)-ifnull(b.stid,0)) from

(select * from stadium where stid = 1) as a,

(select * from stadium where stid = 2) as b