首页 > itarticle > 统计sql

统计sql

admin 11月 13, 2020 0

select
round(sum(a.storage)/1024/1024/1024,2) as total,
sales
from a
left join(
  select custom_id,GROUP_CONCAT(distinct sales_name SEPARATOR ',') as sales
  FROM b
  GROUP BY custom_id
) b ON (a.custom_id = b.custom_id)
group by a.id order by total desc limit 50;