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