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

呵呵,deal_id='null'
try

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

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