SELECT COUNT(*) FROM dbo.AbpUserRoles GROUP BY UserId,RoleId HAVING COUNT(*)>2 SELECT UserId FROM dbo.AbpUserRoles GROUP BY UserId,RoleId HAVING COUNT(*)>2