SELECT
*
FROM
(
SELECT
USER_ID, count( * )
FROM
T_AA_USER_ROLE
GROUP BY USER_ID
ORDER BY COUNT( * ) DESC
)
WHERE ROWNUM <= 10
结果:
SELECT
*
FROM
(
SELECT
USER_ID, count( * )
FROM
T_AA_USER_ROLE
GROUP BY USER_ID
ORDER BY COUNT( * ) DESC
)
WHERE ROWNUM <= 10
结果: