mysql关联查询
来源:互联网 发布:错生网络剧演员表 编辑:程序博客网 时间:2024/05/19 22:23
SELECT t1.res_id,t1.kpi_id,t.`id` AS thid,t1.hostname,t1.kpi_show_name,t1.dataValue
FROM
(SELECT m.res_id,m.kpi_id,m.hostname,m.kpi_show_name,AVG(m.indexValue) AS dataValue
FROM
(SELECT
r.`id` AS res_id,k.`id` AS kpi_id,p.`dateday`,p.`timeday`,p.`hostname`,k.`kpi_show_name`,CONCAT(p.dateday,' ',p.timeday) AS newtime ,p.`indexName`,p.`indexValue`
FROM `t_ovo_host_performance` p ,`business_resource_info` r,`resource_kpis` k
WHERE p.`hostname` = r.`hostname` AND k.`kpi_name` = p.`indexName` AND r.`id`=1) AS m
WHERE m.newtime>='2016-07-11 00:00' AND m.newtime<='2016-07-30 00:00'
GROUP BY m.kpi_show_name) AS t1 LEFT JOIN `threshold_task` t ON t1.res_id = t.res_id AND t1.kpi_id = t.`kpi_id`
FROM
(SELECT m.res_id,m.kpi_id,m.hostname,m.kpi_show_name,AVG(m.indexValue) AS dataValue
FROM
(SELECT
r.`id` AS res_id,k.`id` AS kpi_id,p.`dateday`,p.`timeday`,p.`hostname`,k.`kpi_show_name`,CONCAT(p.dateday,' ',p.timeday) AS newtime ,p.`indexName`,p.`indexValue`
FROM `t_ovo_host_performance` p ,`business_resource_info` r,`resource_kpis` k
WHERE p.`hostname` = r.`hostname` AND k.`kpi_name` = p.`indexName` AND r.`id`=1) AS m
WHERE m.newtime>='2016-07-11 00:00' AND m.newtime<='2016-07-30 00:00'
GROUP BY m.kpi_show_name) AS t1 LEFT JOIN `threshold_task` t ON t1.res_id = t.res_id AND t1.kpi_id = t.`kpi_id`
0 0
- Mysql关联查询
- mysql关联查询原理
- mysql关联查询
- mysql嵌套关联查询
- 谈关联查询-mysql
- MYSQL数据库关联查询
- mysql关联查询
- MySQL关联查询
- mysql中多表不关联查询
- MySQL关联查询
- mysql-(四)-关联查询
- mysql关联查询
- Mysql关联查询
- MySQL多张表关联查询
- mysql数据库关联查询
- MySQL之关联查询
- MySQL关联查询优化实例
- 两个MYSQL表关联查询
- JAVA发送邮件Demo(含附件)
- 用Qemu模拟vexpress-a9 (一) --- 搭建Linux kernel调试环境
- Eclipse上red5插件安装
- ElasticSearch5.0使用记录
- 手动安装linux centos rabbitmq
- mysql关联查询
- Error:(54, 61) 错误: -source 1.6 中不支持 diamond 运算符 (请使用 -source 7 或更高版本以启用 diamond 运算符)
- 如何选择机器学习算法
- Android SDK Manager无法更新,内容显示不全的解决办法
- 5.1 关键字:static
- 谷歌下下雨12号的字体怎么实现
- java接口回调
- android js webview 互调
- CentOS用户权限管理--su与sudo