Find Employees Whose Salary Higher Than Their Manager Salary in SQL | Self Join in SQL

This channel would provide new videos on SQL, ETL and Data warehouse concepts. I would create a separate play list for SQL Tutorials for beginners, advanced concepts, Interview questions and data warehousing concepts

Facebook Page:

Youtube Channel:

[parmindersingh]

Very good example of table joins... Good work bro!!!

[SathishKumar-qrjj]

Select e.id, e.name, e.sal as emp sal, m.sal as mgr sal from table e, table m
Where e.id= m.id and e.sal>m.sal;

[vijay.s-llyq]

select a.empid, a.empname, a.salary, b.salary from
emptable A
join
emptable b
on a.managerid =b.empid
and a.salary >b.salary

[jayanthjay]

How to join 2 tables and get nth highest salary..

[praveenreddy]

what happens if we use E.empidid = M.managerid?