本文介绍了如果为null则为0 SQL的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
代码工作正常，只需要替换laste行为：
Code working fine, just need to replace laste line to be:
IF IS null then 0
一些帮助
我的尝试：
Some help
What I have tried:
select x1.naziv, x1.Nabavka, x2.Prodaja, x1.Nabavka-x2.Prodaja as 'Stanje' from (select naziv, sum(kolicina) as Nabavka from
( select naziv as naziv, convert(float, kolicina) as kolicina from ulazni_racun_roba_roba union all select naziv as naziv, convert(float, kolicina) as kolicina from mp_ulazni_racun_ostalo_roba ) a
group by naziv) x1 left join ( select roba, sum(kolicina) as Prodaja from
( select roba, convert(float, kolicina) as kolicina from mp_racun_roba union all select roba, convert(float, kolicina) as kolicina from mp_faktura_roba ) b
group by roba ) x2 on x1.naziv = x2.roba
where x2.roba is not null 推荐答案
where coalesce(x2.roba, 0) = 0
where isnull(x2.roba, 0) = 0
这篇关于如果为null则为0 SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！