SQL查询值按分钟平均,小时平均,天平均

最新推荐文章于 2023-04-23 15:29:40 发布

BUBsky

最新推荐文章于 2023-04-23 15:29:40 发布

阅读量1.1k

点赞数

分类专栏： SQL

SQL 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

--按分钟平均 
select id,ROUND(AVG(value),2) as avg, date_format(time,'%Y-%m-%d %H:%i') as time from "
+ tablename
+ " where id in (:indexIds) and   time>=:starttime and time<:endtime GROUP BY date_format(monitoring_time,'%Y-%m-%d %H:%i'),_d order by time desc  



--按小时平均 
select id,ROUND(AVG(value),2) as avg, date_format(time,'%Y-%m-%d %H') as time from "
+ tablename
+ " where id in (:indexIds) and   time>=:starttime and time<:endtime GROUP BY date_format(monitoring_time,'%Y-%m-%d %H'),_d order by time desc  



--按天平均 
select id,ROUND(AVG(value),2) as avg, date_format(time,'%Y-%m-%d') as time from "

+ tablename
+ " where id in (:indexIds) and   time>=:starttime and time<:endtime GROUP BY date_format(monitoring_time,'%Y-%m-%d'),_d order by time desc