Self Join in SQL Server Examples | MSSQL Training Tutorial

[@NareshIT]

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

[@kumarimalaka4178]

Thank you so much sir really I saw many videos but I can't understand the concept but the way your explaing is too good.

[@sergerudasingwa7638]

Thanks for your explanations. I tried several videos but couldn't understand. Now i get the concept of self join.

[@pro_man801]

Actually u r videos should be get 1 crore like 🙏

[@sansuthram538]

MR.sudhakar sir your explanation is awesome .and these videos is very help full every student ....can you please upload the equi join and non equi join please

[@lindawlch]

Great job! Explained how self joins work when comparing the rows in the same column. Answered the questions that had confused me for a long time. Thank you!

[@sumitaboro9680]

Best tutorial video on self join so far. Thank you.

[@bhupeshkumar667]

ur session of join is very worthful sir...thank you sir!

[@anithachinna5434]

I'm thankful to you always sir.. very understandable explanation..

[@geethanampalli3134]

excellent sir ....thank u so much given clear explanation.....i like your way of teaching ...

[@chandbashashaik1772]

Great explanation sir 💜 Very easy understandable sir

[@sajeedmohammad8448]

sir nice explanation.. please upload EQUI JOINS AND NONO-EQUI JOINS and also Stored procedures..

[@Lokeshraj1934]

The way of explaination is Awesome sir❤️❤️❤️

[@ayazahmed9762]

Sir, please upload the Equi And non-equi joint please

[@everythinginthespace7383]

there's a video missed about equi and non equi joins.. please upload it sir.. there's no discussion about non ansi joins of equi n non equi joins, these two topics are missed somehow..

[@syedmurtazaali5343]

great explanation and quiet helpful ..for learning the concepts please upload equipment and non equi join video

[@minamishail_Tech2024]

Can we use this statement instead of self join ? Select e.* from EmpDetails e where e.Salary in (select salary from empDetails group by salary having count(salary)>1)

[@bikashkumarparida7595]

select e1.empname from employee as e1 ,employee as e2 where e1.empnamee2.empname and e1.empsalary=e2.empsalary ...i wrote this way

[@Saavi2013]

great explanation , last video ws great i cleared my all doubts ,,,,, thank u so much ... plz upload how to join 3 or 4 tables using

[@jahnavip812]

Sir equi and non equi joins video is not found

[@ArifRaza]

Wonderful lecture! quite easy to understand.

[@varalaxmidevi1113]

Such a detailed video, thank you so much sir

[@hariananthagiri6838]

I think we can do like thz after giveing where ename = smith we get total row details from that we can know salary was 8000 with that same where condition where salary = 8000 we can find other person details also who is haveing same salary that smith haveing . 😀

[@rahulgehlot5742]

pls upload equi n non equi join also its helpful

[@chandankumardas7434]

GREAT JOB SIR,VERY GOOD TEACHING

[@MohammedAzhar1993]

Explained very nicely sir.

[@arupchandra8602]

Sel * from employeedetails where Salary in (select salary from employeedetails where ENAME= "SMITH") it should also work...

[@mbabu3649]

Well sir I have one dout even we don't no empname or empsal how to do in this manner and how to compare?

[@vssrao3917]

Hi sir your teaching lessions are awesome. i didn't see EQUI JOIN NON EQUI JOIN CONCEPT. PLEASE GIVE ME LINK IN THE DESCRIPTION. THANK YOU.

[@shabbirsonu9582]

select ENAME,SAL,JOB from emp where sal in(select sal from emp where ename='SMITH')

[@saikiranp.r6966]

This is correct, this is using subquery.

[@syedmohammed786y]

great!

[@RameshReddySeelam152]

Can anyone please suggest to me if I go through all 47 SQL server videos and practice 100% so do I get maximum knowledge on SQL server?

[@ramramu1236]

awesome explonation, need to appreciate you

[@nithyaprabakaran9631]

Hai sir .. in play list where is ur class sir.. I searched but i cannt find ..

[@tapaskumarpanigrahi8022]

Astronical explanation . mindblowing i am so excited .... ...

[@Chillos100]

Great Job, really clearly explained. thnx

[@yashjk899]

Superb explanation sir thanks

[@swapnavallepu2029]

Simple explanation can understand any one......

[@shyamsundar8665]

Thanks for your time Question : which employees are getting same salary. . In this case... How we are giving static value as Smith... Instead we can use groupBy salary and take count and filter when count > 1

[@saritaahire9029]

sir ,where is equi ani non equi join . is uploaded or not?

[@ritabritabasak5652]

Thank you Sir .... U saved me

[@godblessyou2603]

Expected Example Explanation with Self Referential Integrity Purpose: A FK referring to its own table PK. That helps, Thanks.

[@codingchannel001]

Thank you sir absolutely understood

[@ramakrishnavarma2534]

am waiting for equi join and non equi join video class plz upload it sir

[@swapniljagatap3533]

Thank you so much, Nice explanation!

[@bhaskarreddy9042]

SELF JOINS ONE VIDEO MISSED, WHICH CONTAINS EQUI-JOIN AND NON-EQUI-JOIN PLEASE ADD IT

[@yallasailakshmankumar2714]

Sir U Did not Upload Equi and Non-Equi Join session Please Upload

[@ajaykushawaha2118]

sudhakar sir, plzs you explain store procedure of each part.. and how's different to function and also explain function.

[@vamsialluri5358]

sir, u didn't upload the equi join and non-equi join video session....

[@a.n.7338]

sir is it correct to say that non equi join is just like cross join except for the fact that the colums in which something is missing null is implemented???

[@sandeepmanjunath8004]

wasnt it simpler to use group by clause on salary column ?

[@anilkumarancha9870]

here is the link for equi and non equi join explained by sudhakar sir, thank you sir.

[@dharmendrapradhan6143]

where is the link?

[@Sritezaa]

@@dharmendrapradhan6143 kzbin.info/www/bejne/pp7JcoedasicjbM

[@jananis1621]

excellent teaching

[@nageshchinna4684]

SIR PLEASE UPLOAD EQUI AND NON- EQUI JOINT PLEASE PLESE SIR........

[@tarunmahajan4050]

fantastic explanation

[@hemalatha-pk2hh]

Missed to upload equi and non equi joins videos... Plz upload it ASAP.. Please

[@balachandranr2658]

Link for Equi and non-equi Joint . kzbin.info/www/bejne/pp7JcoedasicjbM

[@wasimahmad2010]

pls upload equi n non equi join

[@chinkuvloger7013]

Sir, please upload equi-join & non equi-join video..

[@rasheedabdul9028]

wh at do u mean by alias??

[@mukeshchandra9430]

Sir you are not add eqi join and non eqi join in playlist

[@morreppagarimohanreddy6770]

hi sir equi and non equi joins video is missed please upload it sir

[@mohansaivelagapudi929]

Thanks for helping sir

[@srinivasy8460]

sir u did not uploaded the equi and non equi join please up load

[@sravankumar1767]

nice explanation..

[@dinatjahanmilitasnim4614]

good explanation

[@Chaitanya_Panchal]

sir how to retrieve the data from more than two tables

[@christal9968]

thank you very much sir

[@anilkumarancha9870]

well explained, thank you .

[@manojphaju]

please upload EQUI and non-EQUI join

[@nrk2892]

Thanks a lot sir 🙏

[@Ajaykumar-hg2ki]

there is no video about equi join and non eqvi join

[@PavanNetha44]

sir Equi,NON equi joins missed please add that video

[@rajunagadasari1160]

EXCELLENT

[@akshaydeshpande8729]

Thank You Sir

[@PRAVWAT]

Not uploaded join and equi join kindly upload

[@pankajkharade8463]

great sir

[@chandinimallidi2516]

Thank you soooo much sir

[@Tejaswi_sings_usa]

Thank you sir :)

[@vivek118611]

I didn't understand this.. Its quite confusing... Thanks for other videos...

[@nishamollick3404]

EQUI & NON-EQUI join are missing .....

[@nagmabanu7627]

Super sir

[@srinivasrao-lw6xk]

You said ... we want to retrieve same employee salary from the table(don't give hint point). Why again u are taking Smith in this query.. I don't know sryyy

[@cococnk388]

Yeah I think he just wanted to teach us how to use ALIAS...

[@cococnk388]

The query can be written as below: SELECT E.NAME, E.SALARY FROM EMPLOYE E, EMPLOYE A WHERE E.SALARY=A.SALARY and E.EIDA.EID; Hope it helps. Thanks

[@aparnabhore9181]

what if I don't know the employee name?

[@tarunsirsath5110]

select * from empdetails e1 , empdetails e2 where e1.salary = e2.salary and e1.eide2.eid

[@raushanthakur661]

@@tarunsirsath5110 Great

[@shikhasingh3976]

But of we don't know the employee name

[@manoharcharla5082]

please upload the missed one

[@shivshankargadade4926]

Sir upload equi and non equi join

[@rjfeelove]

anyone having the link for Equi & NON-Equi join video :(

[@rohanvelhal5077]

sir pllzzzzzzz upload equi and non equi join...

[@sharonroja8257]

Thankyou sir

[@bhagamanusha1496]

Super

[@bharathsagar5683]

Where is the link for Equi join video ?

[@Sritezaa]

Before Class Video which got missed on Equi Join and Non Equi Join Link kzbin.info/www/bejne/pp7JcoedasicjbM

[@josearieldelosreyes8102]

Thanks!

[@josearieldelosreyes8102]

👏👏👏

[@donotsmile98]

👍👍👍👍👍👍👍👍👍👍

[@raazverma8636]

what if I don't know the employee name? u didnt explain;;;;;;;

[@tarunsirsath5110]

select * from empdetails e1 , empdetails e2 where e1.salary = e2.salary and e1.eide2.eid

[@praveshrikhari4026]

SELECT * from table Where salary = 8000 should work

[@cococnk388]

It works if you have information about the salary

[@cococnk388]

The query below also works : SELECT E.NAME, E.SALARY FROM EMPLOYE E, EMPLOYE A WHERE E.SALARY=A.SALARY and E.EIDA.EID;

[@AudioDestinyHQ]

nice

[@raghavendraraj776]

😎👍🏽

[@saidurshamim]

if you explain like this than student will be crazy. LOL

[@venkatramanj868]

Instructor seems to be technically strong but weak in language. If he improves that then his videos would be more useful to many people.

[@databubbles6095]

For this one small topic, why you have taken this much time..boss😭