Thank you so much sir, sql join ka coms- ke liye hum ne TH-cam 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, 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.
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!
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
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.
Thank you very much for such informative video and explaining in detail and making every concept easy to understand! If you can provide some exercise files for practice, it'll be more beneficial!
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
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.
Hello dear I am confusing with question When I read any question so I can’t understand which join should I use so please tell me this how I recognise which join should I use
Ur last few seconds in which u r joining 3 tables but ram kumar is working on department 2 and 3 which means in developing and sales...but ur result shows that ram is working in HR 2 times which is wrong.
![[ ออกกอง ] วัยหนุ่ม 2544 โลกหลังลูกกรง..ทัวร์กองถ่ายหนังใน "คุกของจริง" | JUSTดูIT.](http://i.ytimg.com/vi/vB--aOkZCpw/mqdefault.jpg)
🔥 Get your free certificate of completion for the MySQL Basics Course, Register Now: glacad.me/3z71m2k
Lo lo i
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!!!
bhai aap ko dil se salute aaap ne mera problem solve kr diya thanku so much
Thank you so much sir, sql join ka coms- ke liye hum ne TH-cam 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
Hello sir,
I am from non IT field and after learning a language , this lecture is very useful for further learning
Sir, I am the beginner, and the way you explained the Join concept was really awesome, great help for me Thanks.
gone through so many videos but this is the best to understand.THANK YOU
Explanation style is very nice ...Thank You
लय भारी सर👍👌
You are great, thanks for creating a video in Hindi, its very usefull for me.
Awesome explanation...I had been confused over the join since beginning, but your video made my concept crystal clear...Thanx a lot
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;
Now thats what we call teaching skills .......❤
the lecture is very amazing. i understand all concepts. next week my exams start and your video really helps me a lot
One of the best video on Joins in Hindi....❤️
Thank you Great Learning ❣️😊
Thanks.. Superbly explain.. Simple and sweet
TH-cam pe isse accha video koi nhi
bahut badhiya bataya hai bhaiya ji. Full bhukaaal 🔥🔥🔥
Thank you sir for this teaching us this concept easily and simply
Very beautifully and easily explained.
Indeed
Thanks sir bahut ache tariike se samjaya apne..
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.
Thanks a lot for your valuable session...
In one word... Thank you so much.
I searched for simpler explanation in many websites, This was the best sir. thank you.
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
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.
Well explained, no need watch another videos for beginners
All my doubts are cleared now.Thanks for the video.
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
REALLY REALLY GREAT VIDEO. THANK YOU SO MUCH
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
Very well explained
THANK YOU SO MUCH SIR:)
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!
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 you so much bhaiya ❤️❤️
Self join thoda confusion hua but theek h maza aa gaya... Thanks
very Useful video .Thank you
Guys bestest video must watch ❣️
Great explanation in a very easy way to understand by a beginner. I had confused since I heard the term. Thank you Sir.
one of the best lecture in youtube
teaching way is superb....👌
Brilliantly explained brother. Really awesum
Yaa it's opening an interest and explanation is also very simple that everyone can understand..like a true teacher..thank you sir
Wow really wonderful video sir. I really got all the required knowledge which I wanted in joins
Great job brother appreciate your efforts well teaching...❤
Request for same functions of sql server.
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
It's such a very simple way
I AM PAYING FOR 2 LAKH FOR THE COURSE BUT YOU ARE BETTER THAN AL THOSE ACADEMIC
TEACHERS
Great Explanation sir. Please create full sql course vedio..
Thank you very much !
great job brother...rightly said great learning!!
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.
This lecture is very useful
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
this is the best video i have seen for this topis,do you have dsa course also.
Superb video 🤩.
I really liked it.
Thank you so much sir🎉😇
Perfect video for joins
Really appreciative
Thnks for uploding a video ❤
Great video sir please make on full SQL🙏🙏
Hi Please follow the link to watch SQL full course: th-cam.com/video/PApdxLedQoc/w-d-xo.html
thank you, really helpful.
Best video for Sql joins
Thank you sir ...💖💖
Explained very well
Thank you very much for such informative video and explaining in detail and making every concept easy to understand!
If you can provide some exercise files for practice, it'll be more beneficial!
Very nice 👍 awesome 👍👍👍👍
Best video on 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
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
thank you, this is gem gold
Thanks sir ❤️
mindblowing video
Thank you for the video
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
valuable info.
Plz make video also on subquery with easy & medium level practice problem.
Sir create table pey bhi ek video bana dijiye please
Great explanations
simple explanation
sir, please make a video on PHP 7 new features.
wonderful sir ji
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
u r awesome brother
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
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
Thank you very much
Great video
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
thank a lot sir
Wow yar al clear
sir Oracle Application Express ko kaise use kare iss pe ek tuition pls..
Concept clear
in department table instead of EMP_ID there is DEP_ID
sir can u explain min,max,average function video
Nice video
do we have more videos from same instructor ? what is his name? Thanks
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
Hello dear
I am confusing with question
When I read any question so I can’t understand which join should I use so please tell me this how I recognise which join should I use
Great
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Could tell us more about cross join
does these queries also work on MySQL
Ur last few seconds in which u r joining 3 tables but ram kumar is working on department 2 and 3 which means in developing and sales...but ur result shows that ram is working in HR 2 times which is wrong.
Kindly make plsql tutorial
hello sir ,
one table is one row to apply join using self fliter how to find?