Employees👨‍💻 Taking More Salary🤑 than their Managers👨‍✈️| SQL INTERVIEW QUERIES

[@awaisaslam9022]

Sir, if there is record D with 15000 salary, it would also be listed in query result. So, the query is incorrect... try this (a.manager_id = b.employee_id)

[@sankalproy9978]

This is correct, thanks.

[@sr7821]

This is exactly what i was wondering

[@amitshukla2268]

Great observation Bro :)

[@mithileshshaw7822]

@gate smashers . Please correct me if i am wrong i think the table details that u are showing from time 4:00 is not correct because we will be getting 4 records because id=1 manager id is null and it will not participate in cross join because null will not join with any manager_id

[@deepakkushwah7405]

Good evening sir, sir aap phuch gye punjab and thankyou for guiding GLA ☺️

[@waytosoakshya1127]

Why did we use cross join?

[@samychakraborty4989]

Sir maine iss bar NET qualify kar liya hain ... Apko thanks bol na tha ... Apke lectures mere bahot kaam Aya...thank you so much sir 😊.

[@LieLyrics-gu7dd]

Oo bahiya ommmm phoooo.....😮

[@krushnakhare4117]

mujhe ye question pucha tha 12 LPA salary ke liye

[@nagenderrajput8690]

Useful 🍬

[@chiragmundra5564]

shouldn't it be (a.manager_id = b.employee_id)?

[@wijdana9326]

i think, u r right, by mistake sir has written wrong query & by chance sir's query is working, but we understood, what he was trying to teach.

[@watchlistsclips3196]

Yes it should be

[@awaisaslam9022]

yes it should be! ...

[@aabirchakraborty3033]

@@wijdana9326 can you explain me ?

[@jyotisurana2837]

Sir, why arent you making videos related to gate 2023?

[@rohitsethi5696]

where is scripts

[@ajitpal0821]

Make video title formal don't use emoji.. SMW

[@sudiptadas6243]

Quey galat hoga..is me chalega bt..

[@dharmendraudawat]

sir aap patle hote jaa rhe ho..😟😟

[@shitaldesai9139]

Hello sir

[@Tamanna_K_Hardy]

😏😏😏😎

[@ajitkerle6607]

Apply for paid wfh internship Register now- internshala.com/part-time-nov-22?