表格有下列字段:姓名(name) 商品(goods) 价格(price)
每个人都买了很多的商品,问:购买价值累计超过1w的人有哪些?
表格如下:
1、select name,group_concat(price), SUM(price) as sum from table_name group by name; # group_concat(price) 可以不用
2、价值超过10的人员:select name,sum from (select name,group_concat(price), SUM(price) as sum from table_name group by name) as tt where tt.sum>10;