select (case when 正常计费 then (普通天数*普通单价) when 有节假日(国家规定的)
then (节假日*节假日单价)+(普通天数*普通单价) end) as total from tablename
where datefield between '2003-09-01' and '2003-10-31'
then (节假日*节假日单价)+(普通天数*普通单价) end) as total from tablename
where datefield between '2003-09-01' and '2003-10-31'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货