SELECT*from pm_metric where metric_id in(SELECT metric_id from pm_metric_pair where metric_pair_id in(SELECT metric_pair_id from pm_metric_group_pair_relation where base_group_id =150));
2.性能界面指标组下指标数据的验证
select t1.metric_group_id, t1.base_group_id, t1.metric_group_name, t3.metric_pair_id,
t3.metric_pair_name, t3.metric_unit from pm_metric_group t1
leftjoin pm_metric_group_pair_relation t2 on t1.base_group_id = t2.base_group_id
leftjoin pm_metric_pair_name t3 on t2.metric_pair_id = t3.metric_pair_id
leftjoin pm_metric_pair t4 on t2.metric_pair_id = t4.metric_pair_id
where t1.metric_group_id in(selectdistinct(metric_group_id)from pm_cardtype_porttype where fixed_netype_id =817unionallselectdistinct(metric_group_id)from pm_netype_metype where fixed_netype_id =817)and t4.metric_id in#list