SELECT areaid ,to_char((createtime),'yyyy-mm-dd') createtime ,AVG(idx:: NUMERIC) FROM "XX" where createtime>='2021-09-01 00:00:00' GROUP BY areaid,to_char((createtime),'yyyy-mm-dd') ORDER BY createtime desc
聚合查询统计
最新推荐文章于 2023-06-17 00:40:43 发布