mysql - 如何获取此 mySQL 查询的 COUNT？

Question

如何获取以下查询的行数？

select
hash,page,timestamp, count(*) as total
from behaviour
group by hash,page
having total > 2 AND timestamp >= Now() - interval 5 minute

Answer 1

只需查询即可解决:

SELECT COUNT(*)
FROM (
select
hash,page,timestamp, count(*) as total
from behaviour
group by hash,page
having total > 2 AND timestamp >= Now() - interval 5 minute) AS t1