请教一条oracle的查询语句，如何让没有查询的字段显示为0？

Question

现有一张简单的表

我想要最后显示的结果是这样，该怎么写sql语句，请教

Answer 1

select aa.*,ifnull(bb.cc,0) 
from 
    (select * from 
         (select distinct T from tbl) a,
         (select distinct S from tbl) b) aa
left join 
    (select T,S,count(1) cc from tbl group by T,S) bb
on aa.T=bb.T and aa.S=bb.S;