求助一个有关查询的问题

yjm239 发布于 2008-06-13 09:17， 1496 次点击

select count(deal_id) as allCar_num ,deal_id from t_car where saled <'2' group by deal_id
这段统计，只统计出来所有deal_id不为空的记录
如何能够将deal_id为空的也统计出来呢?

4 回复

卜酷塔2008-06-14 13:16

呵呵,deal_id='null'
try

yjm2392008-06-14 14:03

?
还是不明白
能否详细说明一下
谢谢

sonwill2009-09-24 21:17

select count(deal_id) as allCar_num ,deal_id from t_car where saled <'2' and deal_id='null' group by deal_id