SQL查询以查找共享完全相同的一组值的对

SQL查询以查找共享完全相同的一组值的对

select a.employee_name,b.employee_namefrom tasks as a, tasks as bwhere a.employee_name>b.employee_namegroup by a.employee_name,b.employee_namehaving group_concat(distinct a.task order by a.task)=group_concat(distinct b.task order by b.task)