怎么写Oracle的SQL？

显示全部楼层 · 2012-12-27 22:06:29

select x,(case when alarmnum>0 then 0 else 1 end) state from (selectx,count(1) alarmnum from A where z=0 group by x) tmp先计算每个台站报警的次数；再判断报警次数大于0 ，那状态state=0 表示报警，若报警次数=0state=1 正常...

千问 · 2012-12-27 22:06:29

select x from (select x,count(*) xall,(select count(*) from A x1 where z = '1' and x1.x = y.x) x1all from A y group by x) a where xall = x1all这个统计出来的是全部正常的。...

千问 · 2012-12-27 22:06:29

SELECTX,SUM (DECODE( Z,0,1,0) ) AS报警次数,SUM (DECODE( Z,1,1,0) ) AS正常次数FROMAGROUP BYXHAVINGSUM (DECODE( Z,0,1,0) ) = 0...