分类统计的SQL- -

select count(d.task_id),sum(case when d.status='3' then 1 else 0 end),t.area_id,sum(case when d.status='3' then 1 else 0 end)*1.0/count(d.task_id)
from t_emes_task t,t_emes_detail d
where t.task_id=d.task_id group by t.area_id
 

两位小数的百分数表示22.22%

1、22.22%，25%

select count(d.task_id),sum(case when d.status='3' then 1 else 0 end),t.area_id,
trunc((sum(case when d.status='3' then 1 else 0 end)/count(d.task_id))*100,2)||'%'
from t_emes_task t,t_emes_detail d
where t.task_id=d.task_id group by t.area_id

select count(d.task_id),sum(case when d.status='3' then 1 else 0 end),t.area_id,
trunc((sum(case when d.status='3' then 1 else 0 end)/count(d.task_id))*100,2)||'%'
from t_emes_task t,t_emes_detail d
where t.task_id=d.task_id group by t.area_id

2、22.22%，25.00%

select count(d.task_id),sum(case when d.status='3' then 1 else 0 end),t.area_id,
to_char((sum(case when d.status='3' then 1 else 0 end)/count(d.task_id))*100,99999999.99)||'%'
from t_emes_task t,t_emes_detail d
where t.task_id=d.task_id group by t.area_id