SQL Server Queries Part 12 - Correlated Subqueries

By Andrew Gould

You can see a written explanation of correlated subqueries here:

You can download the script to create the Movies database used in this video at the following link:

You can see the range of resources and courses we offer in SQL Server here:

[rajsingh]

Andrew Gould is seriously one of the best instructors I've found on youtube. You start from scratch, with simple examples and you build on your lesson plans beautifully after that. I cannot thank you enough on how amazing SQL lessons were, as well as your VBA lessons. I thought I had enough knowledge I needed for basic VBA, but still ended up learning a tremendous amount from those videos and then finally SQL. I'll admit I got confused with correlated subqueries, went on to google for a bit, but finally watched this few more times and they finally clicked. Online training courses can be expensive and so I want to thank you for providing SQL and VBA on youtube. It's greatly appreciated. There are a lot of smart people in the world, but not everyone can be a great teacher and you certainly are a great instructor and British accent definitely a plus :)

[QuietLumina]

You’re one of my 2 go-to teachers when I need SQL help. Thanks so much for your work.

[laitai_]

What I like most about your tutorials is how clearly you speak. I'm definitely a fan of your channel. Good job and thanks.

[kamran_desu]

Best explanation of how correlated subqueries actually get processed, makes so much sense now.
Thanks a lot!

[JoeG]

VERY NICE EXPLANATION. correlated subqueries are also great to use in the select clause when you need to do a calculation on data. they're also great when working with the cross apply operator or exists not exists. Great explanation of this function.

[eRockDrums]

Thanks Andrew for the SQL Server Queries videos. Your teaching made it easy for me to understand how SQL queries are created. I appreciate the time you put into making these videos.

[charlyclerfeuille]

Reaching the last part thinking -to my very surprise- "Wait, it is the end already ? But I need more !! I must try these tools."
I remember this kind feeling from a long long time ago, when discovering mathematics/logical problems as a kid with some great teachers, with this particular spark in their eyes/voice.
So now, I going to crunch those exercises from the website because it may seem simple from those 2 hours explanations, but I know that there are the actual challenges / fun.

Thanks a lot Mr Gould / Wise Owl !

P. S : What to joy to feel that my VBA years were not totally in vain.

[Hevletica]

Had to watch it twice. Your entire series is fantastic by all means.

[hddomundo]

I'm from Brazil and I just finished your SQL Queries course with this video. Man, Thank you a lot for all your videos, just help me immensily! But I don't stop here... lol... I grab your text content from your site and put it in my evernote for study more and make a consult when became necessary... Thanks Man!!!

[JoshuaMcClain_JKM]

Hey thanks for this - I was getting wrapped around the axle on Correlated Queries, this help break thru that mental block.

[TopeOlutola]

Awesome work Wise Owl.!!! Simple, Clear, Direct and it just penetrates the brain very easily.

[jackwood]

Using for revision, I have recommended the playlist to my year at uni. Keep up the good work!

[tommyagnew]

Outstanding tutorial! Exactly what I needed to solve a problem I was working on, as I didn't understand how to make the inner subquery dependent on the outer main query. Concise and well spoken, I will check out your other tuts!

[LookLessSeeMore]

Agree with Rajpinderjit - very well explained SQL query - very logical - Thankyou

[mirragemelkyr]

Woah, I'm really happy of finding this channel you're clear and methodic with the basic explanations thanks a lot

[hadireg]

nothing is left random, all precisely explained!! Great Teaching skill! Cheers!

[supa.scoopa]

Thank you so much! Very clearly explained! I'll continue watching your videos!

[youngcolt]

Correlated Subqueries is a relatively tougher topic for beginners. You should add some more examples or small exercises in this video for practice.

[m.a.saberi]

thank WiseOwl for this piece of artwork.
I like your way of teaching.

[PremKumar-wymx]

Really your videos helped me many times to solve real time problems in my project! Thanks a lot ! :)