Hi what is the difference when I use this query to solve the question
SELECT e1.*
FROM emp_manager e1
JOIN emp_manager e2
ON e1.emp_no = e2.manager_no
GROUP BY e1.emp_no;
0 answers ( 0 marked as helpful)
SELECT e1.*
FROM emp_manager e1
JOIN emp_manager e2
ON e1.emp_no = e2.manager_no
GROUP BY e1.emp_no;