select dept, name,
sum(decode(dj, '甲', 1, 0)),
sum(decode(dj, '乙', 1, 0)),
sum(decode(dj, '丙', 1, 0)),
to_char( sum(decode(dj, '甲', 1, 0)) / ( sum(decode(dj, '甲', 1, 0)) + sum(decode(dj, '乙', 1, 0)) + sum(decode(dj, '丙', 1, 0)) ) * 100, 'fm90.00')||'%'
from table_name
group by dept, name;
|