Re: Query for finding count of records that have count(fieldname) > 100

[Peter Brawley]

Well then wrote an outer query to count that ...

select event_time, count(*) as count
from (
  select event_time, signature, count(*) N 
  from t 
  group by event_time, signature
  having N > 2
) repeats
group by event_time;
+------------+-------+
| event_time | count |
+------------+-------+
| 2019-02-10 |     2 |
| 2019-02-11 |     1 |
+------------+-------+