这样?
select case when (spcode=3883 and statfortime < '2006-10-02 17:00' ) then feecode*0.7*0.85 when (spcode=3883 and statfortime >= '2006-10-02 17:00' ) then feecode*0.7*0.8 when spcode=1250 then feecode*0.83*0.85 end as result from $youtable
$youtable:为你的表
select case when (spcode=3883 and statfortime < '2006-10-02 17:00' ) then feecode*0.7*0.85 when (spcode=3883 and statfortime >= '2006-10-02 17:00' ) then feecode*0.7*0.8 when spcode=1250 then feecode*0.83*0.85 end as result from $youtable
$youtable:为你的表
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货