统计数据表中某个字段的值大于2条的数据

select id,member_id,type from visits where type = 1 group by member_id  having count(*) >2;

原文：https://www.cnblogs.com/qxandxt/p/11106100.html