分组查询前三条

SELECT
*
FROM
sys_role_permission main
WHERE
(SELECT COUNT(1)
FROM sys_role_permission sub
WHERE
main.sys_role_id = sub.sys_role_id
AND main.sys_permission_id > sub.sys_permission_id
) < 3;

转载于:https://www.cnblogs.com/ZhangHaiBK/p/9104157.html