select dep_name,sum(workload_full) workload_full,sum(workload_real) workload_real,cast((sum(workload_real)/sum(workload_full)) as numeric(6,2)) as Workload_perc
from jshx_person_workload_rate where reportid=194326 group by dep_name
为查询的数据保留 小数位
select dep_name,sum(workload_full) workload_full,sum(workload_real) workload_real,cast((sum(workload_real)/sum(workload_full)) as numeric(6,2)) as Workload_perc
from jshx_person_workload_rate where reportid=194326 group by dep_name
为查询的数据保留 小数位