select FROM_UNIXTIME(ordtime,'%Y-%m') as month,sum(orderfee) as money ,ywname as ywname from xy_order WHERE orderfee>1 group by month,ywname order by month desc
意思就是按照时间，按照ywname进行分组，并计算orderfee>1的各个分组的数值，并按照月份进行排序。 最佳答案
select FROM_UNIXTIME(ordtime,'%Y-%m') as month,sum(orderfee) as money ,ywname as ywname from xy_order WHERE orderfee>1 group by month,ywname order by month desc
意思就是按照时间，按照ywname进行分组，并计算orderfee>1的各个分组的数值，并按照月份进行排序。