在oracle9i中
select a.deviceitemobject as 测量指标 , count(a.id) as 一般缺陷
from checkresult a
where a.result=30
group by a.deviceitemobject显示结果:
测量指标 严重缺陷
0 37
10 2062
20 2897select a.deviceitemobject as 测量指标 , count(a.id) as 一般缺陷
from checkresult a
where a.result=20
group by a.deviceitemobject显示结果:
测量指标 一般缺陷
0 12
10 3211
20 965我想显示成测量指标 一般缺陷 严重缺陷
0 12 37
10 3211 2062
20 965 2897本人对oracle不太熟悉,求教sql语句怎么写.谢谢了先
select a.deviceitemobject as 测量指标 , count(a.id) as 一般缺陷
from checkresult a
where a.result=30
group by a.deviceitemobject显示结果:
测量指标 严重缺陷
0 37
10 2062
20 2897select a.deviceitemobject as 测量指标 , count(a.id) as 一般缺陷
from checkresult a
where a.result=20
group by a.deviceitemobject显示结果:
测量指标 一般缺陷
0 12
10 3211
20 965我想显示成测量指标 一般缺陷 严重缺陷
0 12 37
10 3211 2062
20 965 2897本人对oracle不太熟悉,求教sql语句怎么写.谢谢了先
解决方案 »
- PL/SQL 执行ORACLE存储过程
- oracle在给表空间添加数据文件时报错
- 硬盘列盘,Oracle数据文件怎么冷恢复出来
- linux 下向oracle数据库中添加汉字出现乱码
- 使用镜像文件在linux中安装oracle10g,谁提供安装全过程 感激不尽
- 请问下面的为什么不能显示呀
- 请问各位大侠 rowid 和 rownum 的区别!急~~小妹十分感谢~
- 请教一个简单的Update问题
- 求显示Oracle错误的信息的帮助文件!!!!Oracle8i Codes and Messages Help
- 如何在sql_plus中,查询某个表的索引值,索引名?
- 在 本地计算机 无法启动 OracleOraHome90ManagementServer 服务
- 如何在一个过程中把日期赋给变量
from (
select a.deviceitemobject as clzb , count(a.id) as ybqx
from checkresult a
where a.result=20
group by a.deviceitemobject
)t1,
(
select a.deviceitemobject as clzb , count(a.id) as yzqx
from checkresult a
where a.result=30
group by a.deviceitemobject
)t2
where t1.clzb = t2.clzb;
sum(case when a.result=30 then 1 else 0) as 严重缺陷,
sum(case when a.result=20 then 1 else 0) as 一般缺陷
from checkresult a
group by a.deviceitemobject
select a.deviceitemobject as 测量指标 ,
sum(case when a.result=30 then 1 else 0) as 严重缺陷,
sum(case when a.result=20 then 1 else 0) as 一般缺陷
from checkresult a
WHERE A.RESULT IN (20,30)
group by a.deviceitemobject