MySQL SubQuery with EXISTS & NOT EXISTS Tutorial in Hindi / Urdu

[@hell_robo]

thanks you sir, after learning basics from you i can learn more by my self.... AND... this way you can fetch more results.... select s_id as "Roll no", name as Student from student where exists(select c_id from course where c_name in ("Btech","BBA")) and c_id in (select c_id from course where c_name in ("Btech","BBA")) order by Student;

[@prakashparamanick2616]

Nice video I got clear overview regarding subqueries

[@sagar3861]

i love how you explains

[@anindian4601]

SUPERB EXPLANATION SIR, KEEP IT UP, PLEASE DO BRING MORE AND MORE SUCH USEFULL VIDEOS. IF POSSIBLE DO VIDEOS ON MATHEMATICS.

[@tahsanhimel8634]

Really great Explanation sir.. I love your all vedio explanation. ❤️❤️ ♟️sir.

[@YahooBaba]

Thanks and welcome :)

[@ArunKumar-jh4qe]

best channel

[@GovindKumar-yz1ke]

Thanks sir, for teaching ...

[@YahooBaba]

Most welcome

[@SalmanAGhani]

Nice explanation.

[@dhruvrajsinhjadeja-vfxarti3085]

Awesome sir :)

[@faisalhayat587]

SooperB Sir Ji

[@YahooBaba]

Thanks :)

[@sagaromer8385]

yahoo baba please ek video corelated subquery pe bhi bana dijiye kaafi confusing topic hai.

[@pritpalsingh4211]

Same result is coming with joins then what is the difference? is there any difference of speed in running query by sql server? It is necessary to know for future usage.

[@rockstarprashantpanth1545]

Using Join first u have to join both tables then u have to apply commands as Select..., But this query helps in reducing command and codes thus saving data and time and efficiency

[@shahzaibidreesahmed4827]

Wonderful

[@mitti-mere-gaon-ki]

best

[@dssingh9955]

Baba ji aap bhout aacha pdhate ho thanks but please Please and PLEASE NESTED SUBQUERY WITH MULTIPLE COLUMNS KE UPAR VIDEO BNA DI JALDI SE AND CORRELATED QUERY KE UPAR BHI WITH RULES AND SYNTAX LIKE YOU ALWAYS DO....PLEASEEEEEEE

[@yashpatil2227]

Nahi bana Google pe dekh lo

[@SandipanSarkar-c8v]

Finished watching

[@XCELTRICKS]

Very Helpful video Bhai but jese aapne Sub query ko where clause me Filter kiya kya humne use show kar skte hai,name ki side me

[@YahooBaba]

Yes u can.

[@rameshbalkrishna598]

Thank u...

[@YahooBaba]

Welcome 😊

[@sagar3861]

thank you sir jee

[@zishamalik3500]

I am getting the error sir it's showing an unknown column 'course' in where clause i rechecked everything do we have to join the tables ?

[@hashirmasood5993]

no you must be writing wrong query, you dont need to join tables to sub query.

[@sagar3861]

sir if i use this SELECT * FROM personal JOIN courses ON personal.courses = courses.cid WHERE cid = "MBA"; ??????????

[@artahir123]

7:28 Exists / Not Exists

[@anupkaushik9370]

What is the use of SubQuery in Real world Projects ?

[@Rehan_Official121]

ye sab command api me work karegi?

[@YahooBaba]

Dear yeh commands MySQL ki commands hai na ki API ki.

[@Rehan_Official121]

@@YahooBaba Thankyou sir for explaination

[@Rehan_Official121]

@@YahooBaba to phir sir ye real time me kaha use hoti ye command

[@radhikagarg206]

Sir the error message has been displayed saying that "Subquery returns more than 1 row" when I apply "IN". How to resolve?

[@hell_robo]

this way you can do... select s_id as "Roll no", name as Student from student where exists(select c_id from course where c_name in ("Btech","BBA")) and c_id in (select c_id from course where c_name in ("Btech","BBA")) order by Student;

[@amigosfriends2104]

Hello sir how can we allow user to create table with their own name in php

[@YahooBaba]

Why you want to allow user to create Table ? I don't think their is any need.

[@amigosfriends2104]

@@YahooBaba sir just asking because if it is possible then I can run my idea very smoothly plss if it is possible tell me

[@shwetajaiswal777]

sir trigger par video banao na

[@vijaykumar-ic7hi]

Wqiting for python tutorials

[@favourite9554]

How many videos remain in this series? ☺

[@YahooBaba]

In MySQL 5 videos are remaining and and in PHP roundabout 50 videos are remaining.

[@favourite9554]

@@YahooBaba thanks When project with pho mysql will be start?

[@YahooBaba]

After completion of MySQL course I will start PHP with MySQL project.

[@sanket1833]

@@YahooBaba sir, are you cover ajax with PHP with MySQL?

[@amritathakur2036]

I think this advance of MYSQL

[@ashwanikumarashu3233]

khana bnane ata h?

[@saketsahu6548]

I am getting an error 1242

[@saketsahu6548]

How to solve please tell me