sql基本运算

SELECT  (PX/(AGFX+PG+ZF+QYZ+KZZ)) as MJB FROM(
select 
case 
when PX is null then 0 else PX 
end as PX, 
case 
when AGFX is null then 0 else AGFX 
end as AGFX, 
case 
when PG is null then 0 else PG 
end as PG, 
case 
when ZF is null then 0 else ZF 
end as ZF, 
case 
when QYZ is null then 0 else QYZ 
end as QYZ, 
case 
when KZZ is null then 0 else KZZ 
end as KZZ
from gp_qjt_mjfh Where GPDM = '002456') A

  

posted @ 2013-05-17 15:19  博宏  阅读(201)  评论(0编辑  收藏  举报