说的很深奥,没看懂 不过看的出来你问的应该是分类汇总的sql语句 select 名称,小名,count(1) 数量 from tablename group by 名称,小名 order by 名称,小名
select 名称,小名,count(小名) from TABLE group by (名称,小名) order by 名称,小名 ; 楼主是要这样的吗
select 名称,小名,count(*) from tb group by 名称,小名 order by 名称,小名
这是你想要的结果吗? with t as ( select 'bbbb' mc,'b3' xm from dual union all select 'aaaa' mc,'a1' xm from dual union all select 'aaaa' mc,'a1' xm from dual union all select 'aaaa' mc,'a2' xm from dual union all select 'aaaa' mc,'a3' xm from dual union all select 'bbbb' mc,'b1' xm from dual union all select 'bbbb' mc,'b1' xm from dual union all select 'bbbb' mc,'b1' xm from dual union all select 'bbbb' mc,'b2' xm from dual union all select 'bbbb' mc,'b3' xm from dual ) select mc, xm,count(xm) sl from t group by rollup(mc,xm)
不过看的出来你问的应该是分类汇总的sql语句
select 名称,小名,count(1) 数量 from tablename group by 名称,小名 order by 名称,小名
楼主是要这样的吗
from tb
group by 名称,小名
order by 名称,小名
with t as
(
select 'bbbb' mc,'b3' xm from dual
union all
select 'aaaa' mc,'a1' xm from dual
union all
select 'aaaa' mc,'a1' xm from dual
union all
select 'aaaa' mc,'a2' xm from dual
union all
select 'aaaa' mc,'a3' xm from dual
union all
select 'bbbb' mc,'b1' xm from dual
union all
select 'bbbb' mc,'b1' xm from dual
union all
select 'bbbb' mc,'b1' xm from dual
union all
select 'bbbb' mc,'b2' xm from dual
union all
select 'bbbb' mc,'b3' xm from dual
)
select mc, xm,count(xm) sl from t group by rollup(mc,xm)