sqlserver 经典sql语句case

select  (alipay_order_num + succ_refund_order_num)  ,case  (alipay_order_num+succ_refund_order_num) when 0 then 1 else  (alipay_order_num+succ_refund_order_num) end   from ysf_ShopTrade nolock


select 
case succ_refund_order_num when 0 then 1 else succ_refund_order_num end as num ,
case  (alipay_order_num+succ_refund_order_num) when 0 then 1 else  (alipay_order_num+succ_refund_order_num)  end as two   ,
case succ_refund_order_num when 0 then 1 else succ_refund_order_num end /case  (alipay_order_num+succ_refund_order_num) when 0 then 1 else  (alipay_order_num+succ_refund_order_num)   end from  ysf_ShopTrade


select  case when (alipay_order_num+succ_refund_order_num)=0 then 0 else (alipay_order_num+succ_refund_order_num)   end  from ysf_ShopTrade
                    


               SELECT  A.seller_id ,
                    A.thedate ,
                    succ_trade_amt AS '已收货金额' ,
                    succ_trade_num AS '交易成功笔数 ' ,
                    succ_auction_num AS '已收货商品数' ,
                    succ_refund_trade_amt AS '退款成功金额' ,
                    case when (alipay_order_num+succ_refund_order_num)=0 then 0
                    else CONVERT(DECIMAL(18, 4), CONVERT(DECIMAL(18, 4), succ_refund_order_num/ CONVERT(DECIMAL(18, 4), (alipay_order_num+succ_refund_order_num)))) end  AS '七天完结率'
            FROM    [dbo].[ysf_ShopTrade] A


select 
seller_id,
thedate,
convert(decimal(18,4), succ_trade_amt)  AS '已收货金额' ,
succ_trade_num AS '交易成功笔数 ' ,
succ_auction_num AS '已收货商品数' ,
succ_refund_trade_amt AS '退款成功金额' ,
1-(case when (alipay_order_num+succ_refund_order_num)=0 then 0 else convert(decimal(18,4),convert(decimal(18,4), succ_refund_order_num/convert(decimal(18,4),(alipay_order_num+succ_refund_order_num))))    end) '七天完结率' from ysf_ShopTrade  where seller_id='601879343' and thedate between 20151222  and 20151227