解决方案 »
- exp oracle 9.2->imp oracle 10.2没反应
- 恳请高人帮忙看下程序
- 百万级数据的表分离数据,都进来看看,给点意见。谢谢。
- Oracle 如何大量插入1000条 好像集合加forall不行样
- 关于数据库中存储图片的问题
- 关于Oracle一个函数
- 如何提高批量更新某一列的速度??
- 对数据库的表每一项操作,比如“delete、insert、update”,在数据库的日志里都有记录吗?我能查看这些操作吗?
- 请问NVL函数中空格怎么表示?
- 我在oracle数据库删除表和导入dmp文件时报了很多错,能帮我看看嘛
- 求一个SQL语句,谢谢
- windows 2003 环境下 oracle 9i 迁移到10g r2(求教)
nvl((select count(t.id) from process t where t.userid = t1.userid),
0) totalNum,
nvl((select count(t.id)
from process t
where t.process_result = 1
and t.userid = t1.userid),
0) passNum,
nvl((select count(t.id)
from process t
where t.process_result = 2
and t.userid = t1.userid),
0) nullNum,
nvl((select count(t.id)
from process t
where t.process_result = 3
and t.userid = t1.userid),
0) uploadNum
from process t1;
nvl((select count(t.id) from process t where t.userid = t1.userid),
0) totalNum,
nvl((select count(t.id)
from process t
where t.process_result = 1
and t.userid = t1.userid),
0) passNum,
nvl((select count(t.id)
from process t
where t.process_result = 2
and t.userid = t1.userid),
0) nullNum,
nvl((select count(t.id)
from process t
where t.process_result = 3
and t.userid = t1.userid),
0) uploadNum
from process t1;
多谢大神,搞定了!
select user_id,count(1) totalNum,count(case process_result when 1 then 1 end) passNum,
count(case process_result when 2 then 1 end) nullNum,
count(case process_result when 3 then 1 end) uploadNum
from process t
group by t.user_id