Easwaran Paramasivam
asked on
How to identify what are the employees has same Roles
I've table as given below. One employee can be assigned to multiple roles. I would like to identify what users has the same set of roles.
Ex
EmpID RoleID
1 2
1 3
4 2
4 3
5 1
I above example, Employees 1 and 4 has same set of roles. Hence I would like to get the result as (1,4).
How to achieve this using query. Please do assist.
Ex
EmpID RoleID
1 2
1 3
4 2
4 3
5 1
I above example, Employees 1 and 4 has same set of roles. Hence I would like to get the result as (1,4).
How to achieve this using query. Please do assist.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER