在Oracle中用group by查询语句查询count(*)数据的时候,发现结果自动忽视了count(*)=0的记录。
select temp_a.XJJBXXID XJJBXXID,count(SID) NUM1
from (select * from XFGL_XJJBXX ) temp_a
**left join**
(select SID from FW_SMS ) temp_b
on temp_a.XJJBXXID = temp_b.SID
group by temp_b.XJJBXXID order by NUM1 DESC