SQL Leetcode 181: Give the Name of Employees Earning More Than Their Managers

Posted on by Admin

Solution:-

select m1.name Employee from Employee m1, employee m2
where m1.managerid is not null
and m1.managerid = m2.id
and m2.managerid is null
and m1.salary>m2.salary;

2 Replies to “SQL Leetcode 181: Give the Name of Employees Earning More Than Their Managers”

  1. I think the admin of this website is in fact working hard in support of his site, because here every stuff is quality based data. Joye Giuseppe Ehrman

Comments are closed.