SQL Server - SubQueries and Correlated SubQueries

[@patnamchandana8756]

Such a wonderful explanation sir even in company training also they didn't teached like you . you are awesome sir.

[@BhaskarJogiSQLandBI]

It's my pleasure

[@dasushivakrishna9253]

Currently are you working?

[@chandrareddy4197]

Bhaskar Sir,you are a Master piece.No one can explain better than this ,all my doubts are cleared . Looking forward to learn more from your videos.

[@BhaskarJogiSQLandBI]

All the best

[@chammu6936]

I have seen a lot of videos to understand co-related sub queries which is not clear. This is the best explanation sir.

[@masoudsalami]

you are a very good teacher with a good rhythm of instructions. My only problem is the English accent. Very good job. Thank you for helping us with SQL.

[@chutkiandsaharsh3435]

WHAT AN EXPLANATION SIR, I HAVE NO WORDS TO EXPRESS YOUR BRIEF DETAILED EXPLANATIONS WITH MUCH SUITABLE EXAMPLES.

[@BhaskarJogiSQLandBI]

Thanks a lot

[@rizzkhan8381]

Very detail and Clear Explanations. Perfect for the beginners, I was struggling to digest the concept of Sub and Correlated queries after watching this video it's very clear to me . Thanks and please keep it up

[@korooshalizadeh]

Imagine if a video made 10 years ago about subqueries is still waaay better than videos made these days!

[@BhaskarJogiSQLandBI]

Thanks a lot

[@shankerm3959]

Before writing a query the main challenge is to stay composed despite the overwhelming scenario the question may present. You did an excellent job of breaking up the question into small chunks to analyze it. Very good work.

[@BhaskarJogiSQLandBI]

Well said!

[@janardhanreddy3267]

thanks bhaskar anna, i don't have any knowledge on SQL , by seeing your videos ,i got better idea

[@BhaskarJogiSQLandBI]

Glad to hear that

[@chanduponnam4445]

Super sir, your teaching is extra ordinary and it is completely high level

[@BhaskarJogiSQLandBI]

Keep watching Eligibility for the course: Any graduation and any year passed out candidates. New Power BI Online batch starts on July 1st, 2022 @ 8 AM IST I will be talking to you personally there. Do not miss to join the demo class. Meeting ID to attend the online class: goonlinetrainingsandconsultancy.webex.com/meet/pbidemo

[@kishoremallipudi560]

Superb explanation.....step by step without any confusion for the persons watching this tutorial

[@bharanibalasubramaniam6057]

Hello Bhaskar Sir - Am from Non technical background who just started to learn SQL, your session was an Master Piece!! Had understood clearly and waiting to test myself on this task :) Thanks a Ton!!

[@BhaskarJogiSQLandBI]

All the best...Thx for watching

[@ssinha3357]

Amazing explanation of Subquery concept with good examples. it is really very helpful. Thanks a lot for sharing this

[@mohanbanoth1405]

Absolutely very good explanation....sir I think u r explanation is like how we have to do in Real time..... Thanks sir......

[@apoorvsaxena1082]

Hello Bhaskar sir, first of all i am very thankful to you, your teaching way is really good, my correlated concept have been cleared after watching this video. So that i want to ask you some concepts in SQL that are still in my doubt list my list is:- 1) Indexes 2) Clustered/Non Clustered 3) Full Text Search 4) Stored Procedures 5) Views 6) Transactions.

[@BhaskarJogiSQLandBI]

You watch my videos on Indexes also. So that these doubts will be clear to you. Thanks for watching.

[@akbarhussain3591]

Dear Bhaskar Sir, You are awesome ... your excellent video(and very clear explanation) cleared all my doubts ... Thanks once again, Sir.

[@anandn5969]

Thank you sir, After watching this video all my doubts about subqueries and corelated subqueries was totally cleared.

[@RaviRanjanKumarraviranjanarya]

Hello Sir, Its a masterpiece explanation ...My all doubts got cleared... Thanks a lot... looking forward to see more...

[@BhaskarJogiSQLandBI]

Thanks for watching

[@anichavan11]

Very good tutorial Bhaskar Sir.. Cleared all doubts.

[@anuragmishra7344]

kudos to u sir. Simply Awesome crystal clear teaching.

[@brianducharme3418]

Excellent Tutorial to understand subqueries - thank you Bhaskar

[@BhaskarJogiSQLandBI]

You're most welcome

[@yunuskureshi904]

fabulous sir....Please keep posting videos ....Thanks

[@kranthiz]

thank you soo much Mr.Bhaskar........it helped me a lot in understanding the basics

[@Vishalkumar-vj7hx]

you are awesome sir . wow mang gaye aapko 10 out of 10

[@paranjothysiddhaiah8684]

Excellent explanation. worth watching this video.

[@parulpatel7571]

Wow excellent explanation. Very detailed. Good job please add more videos.

[@VanithaShetti]

Clearly explained the difference between exists and In

[@BhaskarJogiSQLandBI]

Thanks

[@roopali3369]

thanks for sessions helped me to understand better

[@BhaskarJogiSQLandBI]

Glad to hear that!

[@bhavanapriyankazanavarapu869]

explanation is mindblowing sir. really asome.all my doubts are cleared..for practicing queries , where i will get more to practice

[@dasushivakrishna9253]

Currently are you working?

[@JohnJamalSingh]

Great ..good explanation....really its useful for me

[@My2675]

i think!! subquery is not only within where clause, but the query with in outer query or inner query also known as subquery

[@hareeshkumar6272]

Thank u for clear explanation sir🙏

[@charlesutton]

Really helpful for subquery education. Thanks.

[@BhaskarJogiSQLandBI]

Thx

[@anuragpandey5952]

Very logical and clear explanation

[@PS-le6ty]

Thanks for this explanation..It is really useful

[@ravirajput1734]

Nice... Thank u sir.... Want to see some videos regarding pivot query in sql

[@thuhuongnguyenthi8109]

Thanks sir , you are nicest person in the world

[@maddy2737]

Good explanation 😀

[@spicytuna08]

great explanation on correlated query

[@ganeshtankala8478]

Thank you very much sir then explanation is so super...

[@_LAKSHAWADHWANI]

great explanation!

[@danielleandre8320]

Very instructive tutorial Bhaskar Jogi. Where can I get sample Database your are using?

[@ayeshasarah8995]

Hi sir your teaching is so good , I would like to ask one qst , so my query is , I have to fetch date from datetime column and store it into the same table (column which is having date data type ) for that I used update and subquery but I was not able to store the result , please help me out

[@OsvaldoMaria]

very good explanation .... tottaly enjoyed it

[@jobanu7527]

Great tutorial.Thank you so much sir!!

[@lakkismily2653]

Very good explanation sir....

[@karshad78]

Amazing Explanation...

[@BhaskarJogiSQLandBI]

Glad you liked it

[@prashants4130]

Very helpful Sir 👍

[@roberte9566]

Thank you for your clear explanation.

[@mr.prasadyadav]

Nice Lecture Sir

[@gousesadik]

Thank you sir for this wonderful video ...

[@AnkitKumar-zp4iw]

Thanks a lot sir for such a great explanation

[@sandeepdesai7264]

superb...is there any videos related date function .cause i confused a lot

[@rapuruanil3150]

*Thank you very much sirrrrr.........*video is super .....

[@niteshsingh4377]

@ Bhasker Jogi Please make video on correlated subquery with adventure works database .....thanks in advance.

[@krishna172225]

Hi sir...please upload videos on Triggers and Cursors..

[@sathishkumarchinnadurai6637]

thank you very much to excellent explanations

[@shivaa9150]

Sir i have a doubt in this A-10,B-20,C-30,D-40,E-30,F-40,G-30,H-20,I-30 values are added to (A,B,C,D,E,F,G,H,I) each alphabet has a value how we can remove duplicates ,if we remove duplicates so wt about alphabets can u clarify this

[@kushaltripathi1627]

superb explanation

[@nagendrasappa7319]

Thank you so much sir, this type of explination i will never seen.... And could you please tell me how to find your videos for joins in sql server?

[@mominmaqbul6538]

sappa ga adginav

[@karimtouta6312]

Mr Bhaskar, are you still giving courses ? l need a private sessions . thank you !

[@BhaskarJogiSQLandBI]

Eligibility for the course: Any graduation and any year passed out candidates. New Power BI Online batch starts on July 1st, 2022 @ 8 AM IST I will be talking to you personally there. Do not miss to join the demo class. Meeting ID to attend the online class: goonlinetrainingsandconsultancy.webex.com/meet/pbidemo

[@sandeepkumar-in6lu]

sir when we use correlated subqueries and subqueries...when we should identify

[@smartworld1650]

Great tutorial sir....

[@muralimohan71]

Very Good. Thank you Sir.

[@gvkedsi8790]

select distinct TOP 5 sal from emp order by sal desc; this query is not working in sql*plus can u pls give me solution .....

[@rreddy5201]

really superb explanation thank you sooo much and also i have some doubts in writing some queries even i have mailed you regarding that please check it out sir , thank you

[@sonu1patel]

Hi to practice have your got a sample database that I can download.

[@vikasbisht2192]

oracle live there u can sign up for account and there are scripts available just run and modify them as per your use and save it for next time use.

[@prasadmsbi9136]

very good exp.. thanx

[@sandeepkumar-in6lu]

greatt tutorial sir... will top clause work in mysql sir

[@sudheerbethu9535]

so nice ur explain

[@dataguygamer]

Look up this video, that demonstrates you could have up to 100th level in SQL Server 2017... Search for "Figuring out limitations of SQL Server Derived Tables" or set v = TDtthHbjWtk

[@JunaidAhmed-nv3gk]

Excellent

[@solomon645]

Thank you so much, sir.

[@MoneyMindedJayu]

Very knowledgeable

[@swadhwa7444]

good job .... nicely explained :)

[@shalinichouhan6737]

Gud explaination

[@ashokreddy4083]

Thank you

[@sandeepkumar-in6lu]

can u explain group clause and having clause sir

[@skdonsingh]

Thanks Sir

[@vickyr8826]

Awesome ..........!

[@zawette]

very helpful , thank you

[@anjireddyvinta8861]

Thank you very much sir

[@Vishalkumar-vj7hx]

you are awesome

[@davidmanoharan3882]

sir how to use TOP 3 in oracle?

[@sunnyme8128]

thanks a lot sir..

[@gopanilalitha8905]

Hi basker could you also do the Partion By with examples

[@BhaskarJogiSQLandBI]

Please watch Ranking Functions Video in my channel to get Partition By with examples. I had explained clearly..

[@spicytuna08]

last question can be solved using join

[@BhaskarJogiSQLandBI]

Get all SQL Server (SQL + T-SQL) videos, 03 Case studies, Sample CVs, 1 Real Time Project Explanation at USD 200 only. Contact me : [e-mail]

[@ramaraja6600]

Desktop not visible to viewers

[@trajashekhar9374]

Thanq sir.......

[@shoaibansari9323]

How to find Gender wise nth max balance

[@srinusri9127]

super sir

[@ddd26idb-bisew76]

Good

[@amithalur1]

Any training centre in Bangalore

[@tomlee126]

crystal clear

[@shaikhaziz585]

that top keyword is not working

[@jagwangaming7506]

Hii sir, can you send me notes on multi column and multi row subquery.

[@anooptho4u]

thanks

[@abdiabbi4514]

Wow

[@gangarajuvlogs4119]

Telugu lo chepu man