Re: [SQL ] NVL 相關疑難一問
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
→
03/03 20:18, , 1F
03/03 20:18, 1F
推
03/16 10:13, , 2F
03/16 10:13, 2F
討論串 (同標題文章)
完整討論串 (本文為第 2 之 2 篇):