SQL Server - SubQueries and Correlated SubQueries

Please visit www.GoOnlineTrainings.com/ for details
We have class room trainings at Data Mantra Technologies @ Ameerpet, Hyderabad, India
[e-mail] or call us @ [phone], 96421-43942

[@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?

[@korooshalizadeh]

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

[@BhaskarJogiSQLandBI]

Thanks a lot

[@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.

[@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

[@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.

[@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

[@chutkiandsaharsh3435]

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

[@BhaskarJogiSQLandBI]

Thanks a lot

[@anandn5969]

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

[@kishoremallipudi560]

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

[@ssinha3357]

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

[@akbarhussain3591]

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

[@anuragmishra7344]

kudos to u sir. Simply Awesome crystal clear teaching.

[@mohanbanoth1405]

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

[@anichavan11]

Very good tutorial Bhaskar Sir.. Cleared all doubts.

[@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

[@kranthiz]

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

[@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!

[@ganeshtankala8478]

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

[@yunuskureshi904]

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

[@Vishalkumar-vj7hx]

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

[@RaviRanjanKumarraviranjanarya]

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

[@BhaskarJogiSQLandBI]

Thanks for watching

[@paranjothysiddhaiah8684]

Excellent explanation. worth watching this video.

[@VanithaShetti]

Clearly explained the difference between exists and In

[@BhaskarJogiSQLandBI]

Thanks

[@OsvaldoMaria]

very good explanation .... tottaly enjoyed it

[@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

[@AnkitKumar-zp4iw]

Thanks a lot sir for such a great explanation

[@JohnJamalSingh]

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

[@parulpatel7571]

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

[@roberte9566]

Thank you for your clear explanation.

[@gousesadik]

Thank you sir for this wonderful video ...

[@hareeshkumar6272]

Thank u for clear explanation sir🙏

[@PS-le6ty]

Thanks for this explanation..It is really useful

[@charlesutton]

Really helpful for subquery education. Thanks.

[@BhaskarJogiSQLandBI]

Thx

[@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.

[@spicytuna08]

great explanation on correlated query

[@brianducharme3418]

Excellent Tutorial to understand subqueries - thank you Bhaskar

[@BhaskarJogiSQLandBI]

You're most welcome

[@lakkismily2653]

Very good explanation sir....

[@thuhuongnguyenthi8109]

Thanks sir , you are nicest person in the world

[@anuragpandey5952]

Very logical and clear explanation

[@jobanu7527]

Great tutorial.Thank you so much sir!!

[@sathishkumarchinnadurai6637]

thank you very much to excellent explanations

[@My2675]

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

[@smartworld1650]

Great tutorial sir....

[@roopali3369]

thanks for sessions helped me to understand better

[@BhaskarJogiSQLandBI]

Glad to hear that!

[@shalinichouhan6737]

Gud explaination

[@kushaltripathi1627]

superb explanation

[@zawette]

very helpful , thank you

[@ravirajput1734]

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

[@_LAKSHAWADHWANI]

great explanation!

[@rapuruanil3150]

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

[@prashants4130]

Very helpful Sir 👍

[@muralimohan71]

Very Good. Thank you Sir.

[@sudheerbethu9535]

so nice ur explain

[@maddy2737]

Good explanation 😀

[@anjireddyvinta8861]

Thank you very much sir

[@solomon645]

Thank you so much, sir.

[@jayesh5667]

Very knowledgeable

[@prasadmsbi9136]

very good exp.. thanx

[@sandeepdesai7264]

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

[@danielleandre8320]

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

[@sandeepkumar-in6lu]

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

[@mr.prasadyadav]

Nice Lecture Sir

[@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

[@swadhwa7444]

good job .... nicely explained :)

[@karshad78]

Amazing Explanation...

[@BhaskarJogiSQLandBI]

Glad you liked it

[@Vishalkumar-vj7hx]

you are awesome

[@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?

[@trajashekhar9374]

Thanq sir.......

[@vickyr8826]

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

[@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

[@sunnyme8128]

thanks a lot sir..

[@tomlee126]

crystal clear

[@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

[@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

[@test_account5610]

Excellent

[@krishna172225]

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

[@ashokreddy4083]

Thank you

[@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]

[@srinusri9127]

super sir

[@skdonsingh]

Thanks Sir

[@anooptho4u]

thanks

[@niteshsingh4377]

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

[@sandeepkumar-in6lu]

can u explain group clause and having clause 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 .....

[@sandeepkumar-in6lu]

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

[@ddd26idb-bisew76]

Good

[@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.

[@davidmanoharan3882]

sir how to use TOP 3 in oracle?

[@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

[@spicytuna08]

last question can be solved using join

[@amithalur1]

Any training centre in Bangalore

[@abdiabbi4514]

Wow

[@shoaibansari9323]

How to find Gender wise nth max balance

[@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

[@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..

[@jagwangaming7506]

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

[@shaikhaziz585]

that top keyword is not working

[@ramaraja6600]

Desktop not visible to viewers

[@BhaskarJogiSQLandBI]

Buy MSBI (SSIS, SSAS, SSRS) videos, 01 Mini Project Implementation Video, Sample CVs, 1 Real Time Project Explanation at USD 300 only. Contact me : [e-mail]