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

时间:2019-06-29 12:43:05   收藏:0   阅读:120

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

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!