SQL Server Queries Part 11 - Subqueries

Thank you very much for this video

Great vid!

Best subquery explanation!

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

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

great tutorial, please what text editor did you use

Thank you so much for your efforts sir !

SQL is so fucking boring

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.

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

AMAZING explanation!

'applause'

very very very very useful for me. Thanks very much

Great video! thanks:D

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 $200000000. So obviously nothing should be greater than the max of $200000000 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.

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

thank you from germany

This is a great resource ..

Do you have a book that cover all these chapters please? If yes how can we get this

Nice accent!
which accent is that