Re: [SQL ] NVL 相關疑難一問

[hukhuk (ken)]

SELECT if(car is null ,0,count(*)) as item_count ,carname as car
from tb left outer join ta on tb.carname = ta.car
group by carname;

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 219.87.129.115
→ hukhuk:改成SELECT count(car) as item_count 這樣好了
推 kfei:感謝感謝 學到了一課