Thank you so much sir, sql join ka coms- ke liye hum ne RUclips ka 10 se jada challe ki videos dekh Liya but samaj nehi paye aapke ...1 video me pura complete samaj a Gaya ....tq once again
we can also join 3 tables using following command : select e1.first_name , e1.last_name , e2.dept_name from employee as e1, department as e2 , emp_dept as e3 where e1.emp_id = e3.emp_id and e1.emp_id = e2.emp_id;
Sir , I want to ask that at 33:20 you said we can do it via inner join too but sir we can also do it via Full outer join too incase we are not doing via natural join.
Sir please I tried to listen to other channels about analytical functions but you know they are making me cry 😭😭😭 they are not as good as you no proper explanation.i have searched in videos sir but no video about analytical please 🙏sir make a video on this
Sir, it was very insightful and helpful. Great initiative from Great learning ..this course very helpful. Please come with more basic courses of SQL in parts of 1hr length maximum. So that we can learn better.
Sir can u uploaded full SQL video in hindi that's means jo data analytics ke liye use hota with examples .bahut helpfull hoga agar aap full SQL ka video banaye
Thank you, we're glad we could help you😇 Subscribe to our channel for more such content, and hit the bell icon so you are always notified of updates from us!
The explanation is thoughtful! I have read many articles and videos, but this kind of query in JOINS has been insightful. I have a few questions. While using Joins is to get to merge two or more tables, then why are you using WHERE in the beginning. We can use only one table and will get the result. But here, in the beginning, there are two tables, and you are using WHERE. That means we can use WHERE in another result also. Please let me know if I'm thinking in the wrong direction!
I am very thankful to you for such a great explanations but I don't understand, what is use of 'Cross Join and Self Join'. If possible, please explain. Its beyond my knowledge and understanding.
![SQL Course for Beginners [Full Course]](http://i.ytimg.com/vi/7S_tz1z_5bA/mqdefault.jpg)
🔥 Get your free certificate of completion for the MySQL Basics Course, Register Now: glacad.me/3z71m2k
Lo lo i
लय भारी सर👍👌
Hello sir,
I am from non IT field and after learning a language , this lecture is very useful for further learning
bhai aap ko dil se salute aaap ne mera problem solve kr diya thanku so much
Literally I have No words for comments,this is the perfect video ,i clear my whole concept about joins in only one video.Thanks a lot sirr!!!
bahut badhiya bataya hai bhaiya ji. Full bhukaaal 🔥🔥🔥
Thank you so much sir, sql join ka coms- ke liye hum ne RUclips ka 10 se jada challe ki videos dekh Liya but samaj nehi paye aapke ...1 video me pura complete samaj a Gaya ....tq once again
Now thats what we call teaching skills .......❤
RUclips pe isse accha video koi nhi
Explanation style is very nice ...Thank You
Sir, I am the beginner, and the way you explained the Join concept was really awesome, great help for me Thanks.
I AM PAYING FOR 2 LAKH FOR THE COURSE BUT YOU ARE BETTER THAN AL THOSE ACADEMIC
TEACHERS
In one word... Thank you so much.
gone through so many videos but this is the best to understand.THANK YOU
we can also join 3 tables using following command :
select e1.first_name , e1.last_name , e2.dept_name from employee as e1, department as e2 , emp_dept
as e3 where e1.emp_id = e3.emp_id and e1.emp_id = e2.emp_id;
Thanks sir bahut ache tariike se samjaya apne..
Guys bestest video must watch ❣️
One of the best videos on joins, very easy to learn
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Very beautifully and easily explained.
Indeed
Thank you sir for this teaching us this concept easily and simply
REALLY REALLY GREAT VIDEO. THANK YOU SO MUCH
It's such a very simple way
Thank you very much !
You are great, thanks for creating a video in Hindi, its very usefull for me.
Really appreciative
the lecture is very amazing. i understand all concepts. next week my exams start and your video really helps me a lot
very Useful video .Thank you
One of the best video on Joins in Hindi....❤️
Thank you Great Learning ❣️😊
Perfect video for joins
Awesome explanation...I had been confused over the join since beginning, but your video made my concept crystal clear...Thanx a lot
one of the best lecture in youtube
Thank you soo much Great Learning ❤️
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Sir , I want to ask that at 33:20 you said we can do it via inner join too but sir we can also do it via Full outer join too incase we are not doing via natural join.
Thanks.. Superbly explain.. Simple and sweet
Very nice 👍 awesome 👍👍👍👍
Thanks a lot for your valuable session...
Explained very well
Thank you sir ...💖💖
Well explained, no need watch another videos for beginners
this is the best video i have seen for this topis,do you have dsa course also.
thank you, really helpful.
thankyou so much sir for make this video this video saved my 4 to 6 hrs this is the best i got on youtube today thanks again sir.
valuable info.
your video really cleared my concept about joins brother.
Thanks alot for making such content.
We appreciate it.
👏👏
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Best video for Sql joins
Awesome video sir .i like to your teaching way ....thank you thank you so muchhhhhhh 😊😊
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Thnks for uploding a video ❤
mindblowing video
Very well explained
THANK YOU SO MUCH SIR:)
Sir please I tried to listen to other channels about analytical functions but you know they are making me cry 😭😭😭 they are not as good as you no proper explanation.i have searched in videos sir but no video about analytical please 🙏sir make a video on this
teaching way is superb....👌
Best video on join
Thank you for the video
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Great video sir please make on full SQL🙏🙏
Hi Please follow the link to watch SQL full course: ruclips.net/video/PApdxLedQoc/видео.html
Brilliantly explained brother. Really awesum
Sir create table pey bhi ek video bana dijiye please
Wow yar al clear
Thank you sir it is very helpful
This lecture is very useful
I searched for simpler explanation in many websites, This was the best sir. thank you.
u r awesome brother
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Thanks sir ❤️
Great job brother appreciate your efforts well teaching...❤
Request for same functions of sql server.
Nice .... Explanation
simple explanation
wonderful sir ji
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Thank you so much bhaiya ❤️❤️
Self join thoda confusion hua but theek h maza aa gaya... Thanks
Sir, it was very insightful and helpful. Great initiative from Great learning ..this course very helpful. Please come with more basic courses of SQL in parts of 1hr length maximum. So that we can learn better.
Great Explanation sir. Please create full sql course vedio..
thank you so much sir ji
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Sir can u uploaded full SQL video in hindi that's means jo data analytics ke liye use hota with examples .bahut helpfull hoga agar aap full SQL ka video banaye
Great learning is the great
I revised my concepts 💟💌💕❣️
Thank you, we're glad we could help you😇 Subscribe to our channel for more such content, and hit the bell icon so you are always notified of updates from us!
Great video
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
All my doubts are cleared now.Thanks for the video.
Great explanations
great job brother...rightly said great learning!!
Sir advance java ka toutial hai kya apka
The explanation is thoughtful! I have read many articles and videos, but this kind of query in JOINS has been insightful. I have a few questions. While using Joins is to get to merge two or more tables, then why are you using WHERE in the beginning. We can use only one table and will get the result. But here, in the beginning, there are two tables, and you are using WHERE. That means we can use WHERE in another result also.
Please let me know if I'm thinking in the wrong direction!
thank a lot sir
Great explanation in a very easy way to understand by a beginner. I had confused since I heard the term. Thank you Sir.
thank you, this is gem gold
I am very thankful to you for such a great explanations but I don't understand, what is use of 'Cross Join and Self Join'. If possible, please explain. Its beyond my knowledge and understanding.
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
if we do the code with the help of natural join ,thats is very simple then why we use ,inner join or left join or right join ....can you please help
Wow really wonderful video sir. I really got all the required knowledge which I wanted in joins
Concept clear
Yaa it's opening an interest and explanation is also very simple that everyone can understand..like a true teacher..thank you sir
Thank you very much
Nice video
Superb video 🤩.
I really liked it.
Thank you so much sir🎉😇
Great
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
hello sir ,
one table is one row to apply join using self fliter how to find?
sir Oracle Application Express ko kaise use kare iss pe ek tuition pls..
Sir can you make a video on analytical functions please sir
Hi, Thank you for your valuable suggestion, We will try to look into it and will try to bring the video on our channel
does these queries also work on MySQL
How to write query for cross join
sir 3 table join , aur same mein two table join mein inner join use hua h par amp_id column 2 or 3 Baar repeat kyun nahi hua.
gr8 video
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Nice
00:42
Could tell us more about cross join