oracle根据分组查百分比

create table test20151026(id int, group_name varchar2(10));
insert into test20151026 values (1, 'A');
insert into test20151026 values (2, 'A');
insert into test20151026 values (3, 'A');
insert into test20151026 values (4, 'B');
insert into test20151026 values (5, 'B');
commit;

select group_name, sum_G, sum_G/total*100||'%' as rate from 
  (select group_name, sum(id) as sum_G from test20151026 group by group_name),
  (select sum(id) as total from test20151026);

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29485627/viewspace-1816383/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29485627/viewspace-1816383/