select sum(paymoney) from (SELECT CAST(ActualMoney as DECIMAL(9,2)) paymoney FROM api_bainaplayresult where date_format(CreateTime,'%Y-%m-%d') = '2013-12-20' and ResultCode=0 and ChannelCode='y0hpb04zr3' and Comefrom='mfwx001') as mymoney
转载于:https://my.oschina.net/u/564141/blog/186817