SELECT
sum(SUBSTRING_INDEX(vm_cpu, ',', 1)),sum(SUBSTRING_INDEX(vm_cpu, ',', -1)),sum(SUBSTRING_INDEX(vm_ram, ',', 1)),sum(SUBSTRING_INDEX(vm_ram, ',', -1)),sum(SUBSTRING_INDEX(vm_disk, ',', 1)),sum(SUBSTRING_INDEX(vm_disk, ',', -1)),pod_code
FROM
brooklyns2.business_capacity_report
WHERE
created_at LIKE "2021-09-01%"
group BY
pod_code
sql分组求和
最新推荐文章于 2024-08-05 16:49:43 发布