是否可以选择出现 id >某个值的行？

Question

给定一个表:

tbody> <<tr>22244

userid	活动	位置
1	RoomC	1
	RoomB	1
	RoomB	2
	RoomC	4
3	RoomC	1
3	RoomC	5
3	RoomC	1
3	RoomC	5
	RoomC	1
	RoomC	5

修改后的查询:

SELECT userid
FROM marktable
GROUP BY userid
HAVING COUNT(*) > 2

返回在表中出现2次以上的所有用户。

与操作符IN:

一起使用

SELECT *
FROM marktable
WHERE userid IN (
SELECT userid
FROM marktable
GROUP BY userid
HAVING COUNT(*) > 2
);