34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT JamKind, COUNT(*) AS CT
FROM tblTrafficJam
GROUP BY JamKind
union
select 'Others' as JamKind ,'0' as ct
FROM tblTrafficJam
select a.JamKind, isnull(b.CT,0)
from tbJamKind a
left join (
SELECT JamKind, COUNT(*) AS CT
FROM tblTrafficJam
GROUP BY JamKind
) as b on a.JamKind=b.JamKind