Roles which has User assignment SOQL Queries

How to retrieve only Roles which has User assignment?

SELECT Id, Name, DeveloperName FROM UserRole WHERE Id IN (SELECT UserRoleId FROM User WHERE UserRoleId!='000000000000000')

Roles which has no User Assignment?

SELECT Id, Name, DeveloperName FROM UserRole WHERE Id NOT IN (SELECT UserRoleId FROM User WHERE UserRoleId!='000000000000000')

User Role Limit we can't check withthin Salesforce, I have created an Idea 

 

tHiNk gooD and dO thE bEsT.........MANJU NATH 🌝