35-SELF JOIN in SQL |JOIN Tutorial | JOINS Interview Query |Types of JOIN |Why do we need SELF JOIN

[@javajugadcode1429]

Hiiii salonii Dii happy to tell you I follow your full playlist and finally I crack the job. Thank you so much ❤ Please keep it up I want to learn more from u.....🎉😊

[@CodeEra2020]

We are so glad that you got the job . Many many congratulations🎉🎉😊 Thank you so much for watching our videos

[@javajugadcode1429]

Thank you so much once again🤗

[@ranaprathap8292]

Which company?

[@techinicalocean8733]

You are great 👍

[@maheshmahi9109]

Will you please provide practice questions answer query

[@Meetshah-w5j]

We can solve the question with group by clause.

[@kasadurgaprasad5587]

hii salonii garu so wonderful your teaching so I want your SQL basic to advance tutorial some theoretical content so snd any pdf mam

[@tajkumar6331]

select e1.name as employeename,count(emp.name) as subordinate from emp as e1,emp e2 where e1.id=e2.manager_id group by e1.name;

[@prachithakur7061]

self join m two tables create krege to usme inner join ka use krege mem? pls clear the doubt?

[@ranaprathap8292]

Hii salonii please upload next topic video i am waiting to learn

[@CodeEra2020]

Today we will upload it.

[@ranaprathap8292]

@@CodeEra2020 please put it my SQL installation video

[@CodeEra2020]

@@ranaprathap8292 kzbin.info/www/bejne/ZpOoh56KjJ2nn7c it is already there

[@AbdulJabbar-v9f]

Hey there! If you are good in whole sql software plz let me know ! If you are interested teach me sql and also drop ur mail or online portal so that I can join there or learn some sql in adv

[@sagarsharma6834]

could you please provide the solution of last question

[@kavitha-99]

select manager_id as "Manager" , count(manager_id) as "Subordinates" from emp group by manager_id order by manager_id;

[@ajaydalaya2195]

u r sql champ. u must be earning 25 lakh annually

[@shyamkumar-th4zp]

answer for the question u said

[@AllaboutExperienceReshh]

select e.emp_name,COUNT(e.emp_id) as number_sub_orninates from employee e join employee m on e.emp_id=m.manager_id group by e.emp_name,m.manager_id having COUNT(e.emp_id) m.manager_id; Can you plz let me know,wether this query works for final question you have given r not. If so,plz provide an answer for that plz

[@sushugowda5743]

SELECT m.name as Employee_Name, count(*) as Subordinate_Count FROM employee e JOIN employee m ON e.manager_id = m.emp_id GROUP BY m.name ORDER BY 2 DESC

[@PavanKumar-vt2fj]

Which is the correct one in this

[@prachithakur7061]

self join m two tables create krege to usme inner join ka use krege mem? pls clear the doubt?