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

最新推荐文章于 2023-10-14 21:53:50 发布

有梦青年

最新推荐文章于 2023-10-14 21:53:50 发布

阅读量2.6k

点赞数

分类专栏： sql

本文链接：https://blog.csdn.net/qq_32814555/article/details/78919803

版权

sql 专栏收录该内容

11 篇文章 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