怎么同时抽取不同价格的商品和收费的商品个数

Question

select 商品提供商,sum(decode(goods_fee,5,1,0)) 5元,sum(decode(goods_fee,10,1,0)) 10元,sum(decode(goods_fee,20,1,0)) 20元 from 表 group by 商品提供商

Answer 1

简单：
select goods_provide,goods_fee,count(*) from table_name 
where goods_fee in (&1,&2)
group by goods_provide,goods_fee;
上面的&1,&2就是你输入的价位

Answer 2

select goods_provide,sum(decode(goods_fee,5,1,0)) 5元,sum(decode(goods_fee,10,1,0)) 10元,sum(decode(goods_fee,20,1,0)) 20元 from table_name group by goods_provide where oper_time between to_date('2004-01-01','yyyy-mm-dd') and to_date('2005-01-01','yyyy-mm-dd');