|
select GROUP_CONCAT(a.send_order_id) as send_order_id,b.partner_user_id as partner_user_id, sum(a.need_pay_amount) as num from send_order a join send_order_extend b on a.send_order_id = b.send_order_id
where a.order_import_time>'2019-05-21' group by b.partner_user_id HAVING sum(a.need_pay_amount) > 1000
但是GROUP_CONCAT（）这种方式有个很大的问题就是返回字符串的长度默认最大长度是1024，超过1024字节，字符串将被截断。所以要慎重使用 | 
转播
