sql

最新推荐文章于 2024-08-14 13:50:42 发布

tall913

最新推荐文章于 2024-08-14 13:50:42 发布

阅读量259

点赞数 2

分类专栏：算法设计与分析（王晓东）

本文链接：https://blog.csdn.net/tall913/article/details/73555358

版权

算法设计与分析（王晓东）专栏收录该内容

3 篇文章 0 订阅

订阅专栏

select
parentLocation.id,

parentLocation.name,
(sum(ifnull(vmStatus.running_count,0))) as running_count,
(sum(ifnull(vmStatus.stopped_count,0))) as stopped_count,
(sum(ifnull(vmStatus.hibernated_count,0))) as hibernated_count,
(sum(ifnull(vmStatus.other_count,0))) as other_count,

parentLocation.region_id

from

t_res_azone parentLocation

left join

(select region_id,azone_id,id,collect_time from t_res_pod outerPod where collect_time = (select min(collect_time) from t_res_pod innerPod where innerPod.region_id = outerPod.region_id)) pod

on pod.azone_id = parentLocation.id

left outer join t_cap_vm_status vmStatus
on vmStatus.res_id = pod.id
and vmStatus.collect_time = #{collectTime}
where
parentLocation.collect_time =

(select min(collect_time) from t_res_azone where region_id = parentLocation.region_id)

GROUP BY parentLocation.id