日期:2014-05-20 浏览次数:20790 次
select sum(UserConsumeMoney) as totalMoney, convert(nvarchar(7), ConsumeDay,120) as monthConsume from T_UserConsumeDay group by convert(nvarchar(7), ConsumeDay,120)