Self Join in SQL Server Examples | MSSQL Training Tutorial

** For Online Training Registration: goo.gl/r6kJbB ? Call: [phone]
? Visit Our Website for Classroom Training:
nareshit.in/sql-server-training/
? For Online Training:
nareshit.com/course/sql-serve...
#sqlserver #server #programming #course #Tutorials #Training #Videos
--------------------------
--------------------------
💡 About NareshIT:
"Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
--------------------------
💡 Our Online Training Features:
🎈 Training with Real-Time Experts
🎈 Industry Specific Scenario’s
🎈 Flexible Timings
🎈 Soft Copy of Material
🎈 Share Videos of each and every session.
--------------------------
💡 Please write back to us at
📧 [e-mail]/ 📧 [e-mail] or Call us at the USA: ☎[phone] or India: ☎ [phone]
--------------------------
💡 Check The Below Links
► For Course Reg: goo.gl/r6kJbB
► Subscribe to Our Channel: goo.gl/q9ozyG
► Circle us on G+: plus.google.com/+NareshIT
► Like us on Facebook: / nareshit
► Follow us on Twitter: / nareshitek
► Follow us on Linkedin: goo.gl/CRBZ5F
► Follow us on Instagram: goo.gl/3UXYK3

[@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

[@sergerudasingwa7638]

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

[@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.

[@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!

[@syedmurtazaali5343]

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

[@bhupeshkumar667]

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

[@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

[@anithachinna5434]

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

[@sumitaboro9680]

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

[@pro_man801]

Actually u r videos should be get 1 crore like 🙏

[@Chillos100]

Great Job, really clearly explained. thnx

[@sajeedmohammad8448]

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

[@chandbashashaik1772]

Great explanation sir 💜
Very easy understandable sir

[@geethanampalli3134]

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

[@varalaxmidevi1113]

Such a detailed video, thank you so much sir

[@aloneking1934]

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

[@anilkumarancha9870]

well explained, thank you .

[@ArifRaza]

Wonderful lecture! quite easy to understand.

[@MohammedAzhar1993]

Explained very nicely sir.

[@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..

[@swapniljagatap3533]

Thank you so much, Nice explanation!

[@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)

[@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 . 😀

[@chandankumardas7434]

GREAT JOB SIR,VERY GOOD TEACHING

[@rahulgehlot5742]

pls upload equi n non equi join also its helpful

[@ayazahmed9762]

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

[@ramramu1236]

awesome explonation, need to appreciate you

[@ritabritabasak5652]

Thank you Sir .... U saved me

[@codingchannel001]

Thank you sir absolutely understood

[@tarunmahajan4050]

fantastic explanation

[@yashjk899]

Superb explanation sir thanks

[@nrk2892]

Thanks a lot sir 🙏

[@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???

[@jananis1621]

excellent teaching

[@mohansaivelagapudi929]

Thanks for helping sir

[@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.

[@christal9968]

thank you very much sir

[@chandinimallidi2516]

Thank you soooo much sir

[@saritaahire9029]

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

[@ajaykushawaha2118]

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

[@arupchandra8602]

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

[@TejaswiSureshSingsUSA]

Thank you sir :)

[@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?

[@sravankumar1767]

nice explanation..

[@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

[@ramakrishnavarma2534]

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

[@wasimahmad2010]

pls upload equi n non equi join

[@godblessyou2603]

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

[@akshaydeshpande8729]

Thank You Sir

[@nageshchinna4684]

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

[@yallasailakshmankumar2714]

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

[@Dheeraj-ji9kl]

Thankyou sir

[@dinatjahanmilitasnim4614]

good explanation

[@bhaskarreddy9042]

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

[@swapnavallepu2029]

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

[@vamsialluri5358]

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

[@rajunagadasari1160]

EXCELLENT

[@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?

[@tapaskumarpanigrahi8022]

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

[@josearieldelosreyes8102]

Thanks!

[@josearieldelosreyes8102]

👏👏👏

[@pankajkharade8463]

great sir

[@jahnavip812]

Sir equi and non equi joins video is not found

[@bhagamanusha1496]

Super

[@nagmabanu7627]

Super sir

[@manojphaju]

please upload EQUI and non-EQUI join

[@chinkuvloger7013]

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

[@AudioDestinyHQ]

nice

[@nithyaprabakaran9631]

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

[@morreppagarimohanreddy6770]

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

[@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!

[@sandeepmanjunath8004]

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

[@Chaitanya_Panchal]

sir how to retrieve the data from more than two tables

[@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 ua-cam.com/video/pmfATg5ciWQ/v-deo.html

[@srinivasy8460]

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

[@PavanHandloomworks]

sir Equi,NON equi joins missed please add that video

[@hemalatha-pk2hh]

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

[@balachandranr2658]

Link for Equi and non-equi Joint . ua-cam.com/video/pmfATg5ciWQ/v-deo.html

[@mukeshchandra9430]

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

[@manoharcharla5082]

please upload the missed one

[@donotsmile98]

👍👍👍👍👍👍👍👍👍👍

[@rohanvelhal5077]

sir pllzzzzzzz upload equi and non equi join...

[@shivshankargadade4926]

Sir upload equi and non equi join

[@rasheedabdul9028]

wh at do u mean by alias??

[@vivek118611]

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

[@Ajaykumar-hg2ki]

there is no video about equi join and non eqvi join

[@nishamollick3404]

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

[@PRAVWAT]

Not uploaded join and equi join kindly upload

[@rjfeelove]

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

[@raghavendraraj776]

😎👍🏽

[@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

[@shikhasingh3976]

But of we don't know the employee name

[@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

[@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

[@bharathsagar5683]

Where is the link for Equi join video ?

[@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.

[@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;

[@Sritezaa]

Before Class Video which got missed on Equi Join and Non Equi Join Link ua-cam.com/video/pmfATg5ciWQ/v-deo.html

[@Nissicollections]

Explanation is k.. But english must improve..

[@databubbles6095]

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

[@saidurshamim]

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