Simple Subqueries in the SELECT Column List and CASE - view details
Up until now you have only seen using simple subqueries in the WHERE clause. In this video Scott will introduce using simple subqueries in the SELECT column list and the CASE clause.
Highlights from this video:SELECT column list
simple subquery
CASE clause
simple subquery
Examples of using each
and much more Source: http://www.learnitfirst.com/Course/160/Video/2390/Simple-Subqueries-and-SELECT-and-CASE.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 300 (Intermediate) Length: 12:30 (30.7MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: sql server, queries, subqueries, simple subquery, select column list, case
This video comes from the SQL Server 2005/2008 Queries online training course, Writing Queries for SQL Server (2005/2008 Edition). And be sure to check out even more SQL Server 2008/2005 Query Writing training videos.
