SQL Self Join Concept | Most Asked Interview Question | Employee Salary More than Manager's Salary

In this video we will understand self join concept. Why we need it and how to do it. we will find solution for most asked interview question:
Find employees with salary more than their mangers salary

[spd]

create table emp_manager(emp_id int, emp_name varchar(50), salary int(20), manager_id int(10));
insert into emp_manager values( 1 , 'Ankit', 10000 , 4 );
insert into emp_manager values( 2 , 'Mohit', 15000 , 5 );
insert into emp_manager values( 3 , 'Vikas', 10000 , 4 );
insert into emp_manager values( 4 , 'Rohit', 5000 , 2 );
insert into emp_manager values( 5 , 'Mudit', 12000 , 6 );
insert into emp_manager values( 6 , 'Agam', 12000 , 2 );
insert into emp_manager values( 7 , 'Sanjay', 9000 , 2 );
insert into emp_manager values( 8 , 'Ashish', 5000 , 2 );

[amrutdeshpande]

Using Excel and pasting the manager info next to employee info was a great way of explaining! Thank you. You make the life of a Data person so easy!

[ajinkyaadhotre]

DAMN ! the two table creation on excel was soo good way of explaining ! you earned a subscriber ! 🤩

[kirankapruwan]

I had been searching for self join videos. But I did not understand it's working then I came across ur video and you explained in such a easy way that any layman can understand. Thank u so much. Keep doing such great work.

[Nikhilg-rsiv]

Untill before watching this video I am just joining the tables withing itself and getting the empty table as result lol.
Thank you Ankit bro for explaining clearly and simply.

[vinipowerbi]

It became very easy to understand the concept the way you show joining manager id with the second table emp Thank you so much for the clear understanding

[Ankit-um]

Hamesha ki tarah fir ek doubt solve ho gaya 😂😊
Thank You Sir 🙏💛🙏

[Venom-ykwu]

the most lucid explanation on whole utube without any complication.. amazing bro !!

[ayoushisingh]

Great way of explaination by putting the same table next to the original table. Thanks!!

[sridharmurari]

Great Way to explain with Excel not many would explain in Detail like this !

[sanam]

Great.
Ager long years I am in the correct YouTube channel for SQL. Thanks Ankit.

[sanjanashuklaa]

video was crystal clear😍😍 i don't know how effortlessly i understood this concept because it was you who was explaining thankyou plz make more video on other concepts

[spokenenglishworld]

Thank you so much ankit 100 times...I was not able to understand self join but your video made it possible and i have been searching this kinda content since a long time..thank you so much once again...i dont usually comment but it is worth to do it today☺

[dfkgjdflkg]

as usual, great content. You have been a guru to us. Thanks for your time. It is a selfless act. Thanks again

[shuaibsaqib]

Hi Ankit,
Kindly post the Table schema queries in the description for reference and solution query too..

[hemantsah]

That's how manager have grudges against some employees, they use Ankit Bansal's query. :)

[naveennvnkumar]

You make SQL look so easy, really good. Thanks mate

[rahulranjan]

very crystal clear and detailed explanation

[shubhamsri]

Your video is very helpful, sir. The way you explain complex concepts is very understandable

[aniketraut]

Thank you for these amazing videos its helping me to learn the sql in simplest way.