SQL Server Queries Part 11 - Subqueries

By Andrew Gould

You can view a written version of this tutorial 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:

[MrRomanGuy]

Excellent video as always! Each day as I'm working through our database at work and get stuck, I find that you have a video ready to explain exactly what I need to do.

I love the way you teach, explaining every step clearly and concisely. Thank you!!!

[sergiomogz]

Greater and absolutely clear walk through what in backend service buildup appears to be more complex or scary.

[vamsi]

I have viewed many other videos where the tutor uses Adventureworks or some other which doesn't make much sense.

BUT the beauty of these videos are they are easy to follow with the movie-film database, which most of us understands... Which makes the point clear.

[ashrafmammadov]

explained a lot better than the most of the paid tutorials. Thanks posting such a nice videos and we use them thanking to you

[mjparsons]

Thank you for explaining sub-queries so well. In the past, I used queries in loops to get the same effect. This is much more efficient!

[MsDKAV]

Indeed is like listening to an episode of ELEMENTARY, also helpful, your accent is a plus.

[OSODELANOXXE]

thank you for the explanation very clear and informative I am doing MY SQL server 2008
and this has helped me a

[KoyLu]

I like how you pronounce the "r" like Dracula or some sort of Vampire with a foreign accent. Great job on the video and keep up the good work!

[Ajishuk]

Love the accent!
Thanks a ton, this was extremely helpful :)

[andrewchavarria]

Love the videos, Definitely my go to when I am stuck on something.

[JoeG]

great job! you should do a more detailed video of complex sub queries such as corralated subqueries using Exists/not exists and cross apply.

[Bestodds]

Wow. Thank you. Nice contextual example. Finally getting it. Yes I am.

[krismaly]

It's good video with simple sub queries.
Thanks

[renealbert]

Wonderful information videos. I have a question "2 text boxes in a form. 1 First Name, 2 Last Name. How do you select either or? Search by F Name only or L Name only or both?

[emmanuelmadu]

great tutorial, please what text editor did you use

[jerryjerry]

Hey, WiseOwl guy. In the 'Using a where clause in a subquery' section of this video, the final results left me a bit confused. The initial query used the MAX function on "FilmBudgetDollars" where the "FilmReleaseDate" is less than/before 2000-01-01, which shown that to be So obviously nothing should be greater than the max of before 20001-01-01, right? But then when you nested that query, turning it into a subquery, and pulling in the fields "FilmName", "FilmReleaseDate", and "FilmBudgetDollars", SQL Server some how pulled in data greater than what the MAX function initial pulled, and the data was post 2000-01-01. Why was the subquery restraints bypassed?

Edit: I just noticed the > operator in the upper query section. Ignore this post lol. Also, thanks for the great content.

[keggs]

Thanks, I knew I was missing something somewhere!

[robwm]

Would it be possible for you to explain how to find computers that have two specific software titles installed?

[keggs]

How do you write a sub query that excludes data, such as find employees who's title is NOT 'Dr" ?

[MrMLBson]

hey WiseOwl, do you have a video on subqueries in the from statement? I don't understand why they work and why you would do them instead of inner joins.