select t.*
from card_test t
where 1 = 1
group by t.userid
having count(t.userid) > 1;
MYSQL记录having大于1的记录数
最新推荐文章于 2022-05-23 14:09:40 发布
select t.*
from card_test t
where 1 = 1
group by t.userid
having count(t.userid) > 1;