请教一个sql语句(在线等) select a.money-b.money as diff from a left outer join b on a.id=b.id不好意思,sql写错了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用isnull判断select isnull(a.money,0)-isnull(b.money,0) as diff from a left outer join b on a.id=b.id 或者这样,但不如2楼的好select case when b.money is null then a.money else a.money-b.money end diff from a left outer join b on a.id=b.id select a.money - isnull(b.money,0) as diff from a left join b on a.id=b.id select a.money-b.money as diff from a ,b where a.id*=b.id and a.money-b.money*=a.money select a.money-b.money as diff from a ,b where a.id*=b.id and a.money-b.money*=a.money 关于重置自增列 请问如何在SQLSERVER中测试并得到SQL语句运行时间? SQL简单的存储过程用法在线等 求一个存储过程,感谢各位大神,先 我的xp的系统装了一个sql server 2000,但是它里面的企业管理器有问题 让SQL的表按日期每天自动重名表的SQL语句 如何查询这个 还是关于触发器问题??? 找错误!! 效率問題:rs.Open "table1", conn, adOpenStatic, adLockBatchOptimistic 怎么用Select分别从不同的两个条件中,同时生成两个字段:expr1和expr2 SQL这么多阻塞BLK[图] 求助
select
isnull(a.money,0)-isnull(b.money,0) as diff
from a
left outer join b on a.id=b.id
select
case when b.money is null then
a.money
else
a.money-b.money
end diff
from a
left outer join b on a.id=b.id
from a left join b on a.id=b.id
select a.money-b.money as diff from a ,b where a.id*=b.id and a.money-b.money*=a.money
select a.money-b.money as diff from a ,b where a.id*=b.id and a.money-b.money*=a.money