sql中case 用法

原创于 2011-10-08 09:27:13 发布 · 966 阅读

CC 4.0 BY-SA版权

文章标签：

select scdate  ,xwjys  ,xwjyje ,yljys ,yljyje ,dkbs  ,dkje ,ckbs ,ckje from(select targetres.scdate ,
       nvl(targetres.screcord,0) as xwjys,
       nvl(targetres.sctotal,0)  as xwjyje,
       nvl(targetres.ylrecord,0) as yljys,
       nvl(targetres.yltotal,0)  as yljyje,
       abs(case when nvl(targetres.screcord,0) - nvl(targetres.ylrecord,0)<0 then  nvl(targetres.screcord,0) - nvl(targetres.ylrecord,0) else 0 end )as dkbs,
       abs(case when nvl(targetres.sctotal,0) - nvl(targetres.yltotal,0)<0 then nvl(targetres.sctotal,0) - nvl(targetres.yltotal,0) else 0 end  ) as dkje ,
       abs(case when nvl(targetres.screcord,0) - nvl(targetres.ylrecord,0)>0 then  nvl(targetres.screcord,0) - nvl(targetres.ylrecord,0) else 0 end )as ckbs,
       abs(case when nvl(targetres.sctotal,0) - nvl(targetres.yltotal,0)>0 then nvl(targetres.sctotal,0) - nvl(targetres.yltotal,0) else 0 end  ) as ckje
  from