oracle 统计
来源:互联网 发布:电动汽车充电软件 编辑:程序博客网 时间:2024/06/06 00:00
select a.emp_id,
bsu.emp_no,
bsu.emp_name,
bo.name,
sp0 + sp1 + sp2 + sp3 + sp5 + sp6 + sp7 + sp8 + sp9 + sp10 as tot_cnt,
sp,
sp0,
sp1,
sp2,
sp3,
sp5,
sp6,
sp7,
sp8,
sp9,
sp10,
case
when sp > 0 and sp0 > 0 then
to_char(sp0 / sp * 100, '999') || '%'
else
'0%'
end p
from (select emp_id,
count(1) tot_cnt,
count(case
when task_type = 1 or task_type = 4 then
1
end) sp,
count(case
when task_type in ('1', '4') and result_comment = '通过' then
1
end) sp0,
count(case
when task_type = 2 or task_type = 6 then
1
end) sp1,
count(case
when task_type = 3 or task_type = 8 or task_type = 9 then
1
end) sp2,
count(case
when task_type = 5 then
1
end) sp3,
count(case
when task_type = 10 or task_type = 101 then
1
end) sp5,
count(case
when task_type = 11 then
1
end) sp6,
count(case
when task_type = 12 then
1
end) sp7,
count(case
when task_type = 13 then
1
end) sp8,
count(case
when task_type = 14 then
1
end) sp9,
count(case
when task_type = 7 then
1
end) sp10
from mess_task
where status = 3
and org_id in (select org_id from base_organization)
group by emp_id) a,
base_sys_user bsu,
base_organization bo
where a.emp_id = bsu.emp_id
and bsu.org_id = bo.org_id
order by emp_id
bsu.emp_no,
bsu.emp_name,
bo.name,
sp0 + sp1 + sp2 + sp3 + sp5 + sp6 + sp7 + sp8 + sp9 + sp10 as tot_cnt,
sp,
sp0,
sp1,
sp2,
sp3,
sp5,
sp6,
sp7,
sp8,
sp9,
sp10,
case
when sp > 0 and sp0 > 0 then
to_char(sp0 / sp * 100, '999') || '%'
else
'0%'
end p
from (select emp_id,
count(1) tot_cnt,
count(case
when task_type = 1 or task_type = 4 then
1
end) sp,
count(case
when task_type in ('1', '4') and result_comment = '通过' then
1
end) sp0,
count(case
when task_type = 2 or task_type = 6 then
1
end) sp1,
count(case
when task_type = 3 or task_type = 8 or task_type = 9 then
1
end) sp2,
count(case
when task_type = 5 then
1
end) sp3,
count(case
when task_type = 10 or task_type = 101 then
1
end) sp5,
count(case
when task_type = 11 then
1
end) sp6,
count(case
when task_type = 12 then
1
end) sp7,
count(case
when task_type = 13 then
1
end) sp8,
count(case
when task_type = 14 then
1
end) sp9,
count(case
when task_type = 7 then
1
end) sp10
from mess_task
where status = 3
and org_id in (select org_id from base_organization)
group by emp_id) a,
base_sys_user bsu,
base_organization bo
where a.emp_id = bsu.emp_id
and bsu.org_id = bo.org_id
order by emp_id
0 0
- oracle 统计
- oracle统计
- oracle表统计
- oracle索引统计
- oracle分组统计
- oracle统计函数
- oracle间隔时间段统计
- oracle sql 分组统计
- oracle统计信息收集
- oracle分组统计sql
- oracle统计信息收集
- oracle 统计信息是什么
- oracle 逗号分割 统计
- ORACLE统计信息
- oracle中的数据统计
- 收集oracle统计信息
- 收集oracle统计信息
- ORACLE 统计分组语句
- strcmp函数和strcpy函数
- 隐式Intent 你又知多少?
- Leetcode374. Guess Number Higher or Lower
- 统计数组中26个字母出现的次数
- PAT_乙级 1012 数字分类
- oracle 统计
- 如何做一个简单的自动化压力测试
- linux服务器出现大量CLOSE_WAIT状态的连接
- 一些小知识点(五)未完待续。。。
- wait,notify,notifyall详细介绍
- string.Format对C#字符串格式化
- 使用 iptables 限制黑客猜密码
- JavaScript中数组的常用方法
- MySql数据库 sql查询增加序号的伪列