试图获得计数结果集的平均值

作者: 狗头军师
发布时间: 2025-01-10 04:06:49 (14天前)

2 条回复

1#
回复此人
v-star*위위 | 2020-08-07 14-24

您只可以将查询作为子查询： ``` SELECT avg(count) FROM ( SELECT COUNT (*) AS Count FROM Table T WHERE T.Update_time = (SELECT MAX (B.Update_time ) FROM Table B WHERE (B.Id = T.Id)) GROUP BY T.Grouping ) as counts ``` 编辑：我认为这应该是相同的： ``` SELECT count(*) / count(distinct T.Grouping) FROM Table T WHERE T.Update_time = (SELECT MAX (B.Update_time) FROM Table B WHERE (B.Id = T.Id)) ```

编辑

登录后才能参与评论