SQL Server Queries Part 11 - Subqueries

preview_player
Показать описание

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:

Рекомендации по теме
Комментарии
Автор

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

MrRomanGuy
Автор

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

sergiomogz
Автор

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.

vamsi
Автор

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

ashrafmammadov
Автор

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!

mjparsons
Автор

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

MsDKAV
Автор

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

OSODELANOXXE
Автор

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!

KoyLu
Автор

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

Ajishuk
Автор

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

andrewchavarria
Автор

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

JoeG
Автор

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

Bestodds
Автор

It's good video with simple sub queries.
Thanks

krismaly
Автор

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?

renealbert
Автор

great tutorial, please what text editor did you use

emmanuelmadu
Автор

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.

jerryjerry
Автор

Thanks, I knew I was missing something somewhere!

keggs
Автор

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

robwm
Автор

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

keggs
Автор

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.

MrMLBson
join shbcf.ru