17,086
社区成员
发帖
与我相关
我的任务
分享
select class,
sum(decode(code,'001',1,0)),
sum(decode(code,'002',1,0)),
sum(decode(code,'003',1,0)) from tt order by class,code
SQL> select class,
2 sum(decode(code,'001',1,0)) 分区1数,
3 sum(decode(code,'002',1,0)) 分区2数,
4 sum(decode(code,'003',1,0)) 分区3数,
5 sum(decode(code,'004',1,0)) 分区4数
6 from tt
7 group by class
8 order by class;
CLASS 分区1数 分区2数 分区3数 分区4数
---------- ---------- ---------- ---------- ----------
大米 0 0 0 1
玉米 3 2 0 0
稻谷 0 0 1 0
select class,
sum(decode(code,'001',1,0)) 分区1数,
sum(decode(code,'002',1,0)) 分区2数,
sum(decode(code,'003',1,0)) 分区3数,
sum(decode(code,'004',1,0)) 分区4数
from tt
group by class
order by class;