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

　　

转载于:https://www.cnblogs.com/hb-strive/archive/2013/05/17/3083742.html