sql中怎么计算两列的差?

Question

.

Answer 1

假设A列B列都是数值型
select (A-B) as 差 from 表

假设A列B列都是字符型或转换成字符型
select replace(A,B,'') as 差 from 表本回答被网友采纳

Answer 2

直接减
如 (column1 - column2) AS result

这是对的

select (column1 - column2) AS result from talbename本回答被提问者采纳

Answer 3

select 实发工资,补助工资,实发工资-补助工资 as 基本工资
from saleTable

Answer 4

直接减
如 (column1 - column2) AS result

Answer 5

你说的还不是很清楚：
select
sum(isnull(a,0))-sum(isnull(b,0))
from
表名