In the last post (Demystifying T-SQL Subqueries – Part I) we looked at how to use scalar subqueries. Let’s continue our subquery adventure.
As with Part I, the following T-SQL query samples are using the Chinook database.
Subqueries which return a single list of values
or Column List
or Single List of Values
Download PDF file
I typically use SQL Server VMs for my development and administration classes. I want the students to have full autonomy over the machines they are using, so that they can try out different features and configurations without worrying about wrecking a whole lab machine.