Lec-64: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System

[@sumedhvichare1388]

GOAT SQL teacher

[@Toxicboi-nr1ty]

Goat har computer subject me hai

[@Ranganadhamkrishnachaitanya27]

Camel

[@manojkalyan94]

Bro u r my god in SQL with out u never thought SQL would be so easy god bless u bro with more knowledge

[@iconic08]

typical hindu.

[@sauravVocals]

@@iconic08 what 😂

[@samreensamiullah2383]

Couldn't understand anything in college online classes and tution..bt U explain it in such an easy way...Thank u so much sir ...Keep going ... Really appeciate ur hardwork

[@ravneetkaur7075]

Colleges want to increase their revenue ... n try their level best to grab as much as they can ... without giving any concern. How parents earn ... but KZbin pe u r the best teacher veer g ... u r so concerned abt each n every point

[@sourabhmori8129]

Sir your teaching technique is superb...... 😊 I understand everything that you can tech....

[@oshniklife9661]

Varun sir U r great.. U r doing great work...it will give u reward oneday...

[@AYJ959]

more than million subscribers now

[@shubhampawar1012]

Best video series for learning queries writing. Thank you so much sir

[@shreyashjoshi4188]

best tutorial i ever saw on dbms.

[@snehasharma4520]

Very short, informative and useful video.... appreciate your efforts......

[@Motivation-U-123]

thnkew for ur easy tutorials..... tomorrow is my dbms exam ,

[@animationcrust1993]

Sir , in this lockdown we are not able to go to clg ...but you are completing my syllabus ... Thank you so much sir ☺️🙏

[@SheikhShakir-jo1kp]

Love from Kashmir... 10000000M likes and love...

[@keshavd4131]

Awesome explanation the way u explained is really great...we need more video from you...

[@unique_identity7129]

Such a great teacher Explains in simplest way Thank you soo much its really very helpful for me

[@ravneetkaur7075]

I wish u were there in my college faculty ... I would hv a gd future ... ... but u r helping us with such honest efforts that it seems easy to get success ...

[@bhanupratapmudgal4831]

He works in LPU

[@nihalsingh5558]

Really glad sir just commented today to upload videos on queries and instant result 🙏

[@karankandpalvlogs415]

Extremely talented teacher I have ever seen 🙏

[@Thetradersclub_]

5 saal ho Gaye Aaj iss video ko.

[@satyafun6058]

Bhai sara confusion clear kar dete hai ak dam base se samjhate ho maja aa gaya

[@rajbilwe1747]

thanku sir for explainning all these topic in easy manner

[@alwaysanchi]

Sir , you're great

[@RajkumarSingh-ix6xw]

1=2 result dega? Haa dega false(Savage moment)

[@accelerate8646]

One of the best teacher ever

[@sahilsharma7013]

I m watching topics at 1.5 speed n still understanding clearly. Nice work u saved my time sir

[@anshumandas5392]

m watching at 2.5

[@avejessi4175]

@@anshumandas5392 It doesnt exist

[@engineer8340]

Bahut badhiya Bahut Badhiya

[@abuzargore8240]

Thnx alott sir for the amazing explation. Coz of u i m able to understand the concept of sql as well as dbms soo easily ❤️🙌

[@shivanshutyagi83]

Very helpful ! Thanks for ❤

[@azimsarbar1281]

sir your way of teaching is very good and easy to understand . thank you very much sir .

[@akshaykadam4692]

Bhaiiii App Mere Leye Bhagwan Ho.... 100000000 Namaskar, great of allllll

[@azankhan9558]

What a teacher. Love from Pakistan

[@meditationandrelaxationmus741]

Thanks for the wonderful videos

[@Dynamic.programing]

U r great sir

[@muhammadiqbalbazmi9275]

keep being awesome, I will be saying congratulation

[@259_parthpatidar9]

sir ,you also study from here 😊

[@willturner3440]

Really love your content sir, god bless you

[@abhishekupadhyay7261]

Happy Teacher's Day Sir ji🙏🙏

[@bicchisingh2913]

😊😊😊great. 🤗🤗

[@gopalchaudhary6170]

Outstanding explanation ❤️🙏

[@mohammadfaisalirani3899]

Dear Your presentation is nice. I am learning from your tutorial nicely. Thanks for such types of totorial. Mohammad Faisal Irani Dhaka, Bangladesh

[@rishabhtiwari4279]

Hindi kha seekhi bhai

[@sajansekhu8785]

vry nyc sir.....God bless u forever...🙏🙏

[@anshupriya5199]

sir tupple relational calculus ,trigger,assertion .....ye sb par v video bnaiye ...... and thanku sir for explainning all these topic in easy manner

[@kirandoomraarora7191]

sachi muchi vala thnku sir g...i m big fan of u

[@OmitA25]

very nice sir................

[@krishanudutta2943]

Excellent sir

[@kss2066]

Best teacher

[@divyeshkashiyani9214]

good sir explain very nice

[@namratanikam7566]

Awesome😊😊

[@SB_Roy_Vlogs]

great work,,,,,,dada

[@abhishekmaurya9503]

Thank you so much sir

[@LifewRoshu]

Thank you soo much sir

[@toufikurrahmantoufik5368]

Thank you, brother. from Dhaka , bangladesh

[@continnum_radhe-radhe]

❤❤❤

[@abidrather36]

Sir with love from kashmir lots of love

[@rabindramaharjana1100]

U r superb sir

[@divyaagarwal3563]

Thankyou sir😊

[@gauravgupta8441]

You are gentle man

[@amarshinde8257]

nice

[@Sandeepkumar-hf3re]

Sir please make video on B -TREE in algorithm

[@shahinparween3496]

Thank you sir

[@ritwik9489]

Or we can also do--> where address Not In('Bangalore') because that will include rest

[@uamrshahbaz9391]

Jnab love from pakistan

[@krishnasiddhartha]

bless u

[@GateSmashers]

Thank you for your blessings..

[@umeshchoudhari1024]

Very well explained 👏.. Sir, can you please share lecture 59 which is I think missing in this Playlist.

[@suchetabhatia4473]

Thanku sir

[@vivekgupta5041]

Explained nicely in simple language making it easy to understand !!! But I would humbly suggest that please be less repetitive so that less time is needed for watching your videos !!!

[@rupalikawalge5900]

thank you sir, it helps me alot

[@bhaveshjhawar9532]

sir your tuttorials are quite useful but just one problem they are not arranged in this playlist its very tough as to which videos we have to watch in sequence

[@Manish7759]

love from nepal

[@hostswap2182]

nice sir

[@push_freebird6693]

nice😀😀😀😀😀😀😀😀😀

[@viralvideoa]

Thankyou sir

[@sagarpatel4363]

Thanks a lot sir

[@GateSmashers]

Most welcome

[@orange_brat]

thank u very much bhai

[@hafsakhalil7458]

Acha tha

[@amanchaurasiya6238]

So, there we can use a variable at the place after IN or NOT IN, But, the variable should be an array . Right Sir ?

[@vijayinfo777]

select * from emp,project where emp.eid=project.eid and Address In ('chd','delhi','Pune')

[@shabashvalishaik6568]

getting so much clarity on sub queries thanks alot sir and i want ( CORELATED sub queries also ) please give me solution i am confused about CORELATED sub queries thanks in advance

[@092_nishantasnani8]

sir can we use a logical operator or in here like Where address='delhi' or address='pune' or address='chandigarh'

[@oliver_comp]

😍👍😍😍

[@meenakshibhardwaj9441]

M learning SQL FM online sources only....nd m FM non computer background.Is it d right path fr me????

[@StudyWithCuriousExplorer]

Sir thanks a lot for these wonderful lectures but i think sequence of lecture is not proper in the playlist.

[@billypentester]

Sir! What's the use of 2nd table??

[@jahangirahmed8813]

Sir please deliver lecture on Semi Join in SQL.

[@bint-i-akbar_foodshorts]

👍👍

[@sayaksen3359]

what if we make a relational table containing primary key of both tables and refer to that as the third table and fish the values from there?

[@30_harshadmahajan46]

sir kya aap programs bhi karvate ho

[@vijayinfo777]

select * from emp,project where emp.eid=project.eid and Address In ('chd','delhi','Pune') so we don't have to use joins ?

[@kanakaraju7470]

Why are you making it complicated?

[@Mehedihasan-rahat]

But sir if I use or gate consecutively in place of IN operator then what is the disbenefit??

[@pragatichaturvedi1997]

SELECT * FROM Employee WHERE address ='Delhi' Or address ='chd' OR address ='pune';

[@rubykumari7891]

Plz make video on sqlite

[@alkasingh8507]

can you please prepare a video on Explain Plan in Oracle

[@GemoisLive]

Select *from emp where address='delhi' or address='chd' or address='pune' ; is it correct??

[@prashunprateek9085]

[@piyushranjan1890]

Sir.. What will be the output of the query --> Select * from Emp inner join Project on Emp.EId=Project.EId where address in ("Delhi", "Chandigarh", "Pune"). Will it print all details from both the table who is from delhi, chandigarh, pune??

[@suchismitadalal1693]

It will show only the detail of Emp table.

[@Mehedihasan-rahat]

​@@suchismitadalal1693But sir if I use or gate consecutively in place of IN operator then what is the disbenefit??

[@tarunbhatia9791]

Varun sir.. Plz july 2018 me sql series pe question h ,vo solve krke video upload kr do

[@mohdtoufique7446]

can we use or operator insted of in operator in this querry?

[@akash2010karhe]

Can I use "select * from emp where address = 'Delhi' or 'pune' or 'chd' "

[@GateSmashers]

You should use 'In' operator Where address in('D','p')

[@abvlogs860]

Yes this will also work ..

[@abhishekmaurya9503]

This will not work, because in OR operator,if the first most condition is satisfied, execution will not happen further. i.e. only details of emp working in delhi will be as output. Use IN/NOT IN

[@DaaalMakhani]

Sir, this query doesn't work only gives one output. select * from emp where address in ('pune', 'delhi', 'chd')

[@ravneetkaur7075]

Sir ... plz suggest any book of dbms??

[@shivatiwari1127]

Why we take 2nd table .... of project ???

[@jyotirmoymukherjee6432]

sir whats the use of second table here then?