如何去掉select count(*) 返回的NULL值
yyz79 2004-09-16 04:19:57 select d.no,count(d.no) as exam from {oj(select id from table1 )as b left outer join (select id,no from car )as d on b.id= d.id} group by d.no order by count(d.no) desc
我每次执行后总会返回一行
null 0
可是我不想要这一行,如何去掉呢