chap07 - Chapter 7 Subqueries Chapter 7 Introduction to 1...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 7 Introduction to 1 Chapter 7 Subqueries
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 7 Introduction to 2 Chapter Objectives Determine when it is appropriate to use a subquery Identify which clauses can contain subqueries Distinguish between an outer query and a subquery Use a single-row subquery in a WHERE clause Use a single-row subquery in a HAVING clause Use a single-row subquery in a SELECT clause
Background image of page 2
Chapter 7 Introduction to 3 Chapter Objectives Distinguish between single-row and multiple- row comparison operators Use a multiple-row subquery in a WHERE clause Use a multiple-row subquery in a HAVING clause Use a multiple-column subquery in a WHERE clause
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 7 Introduction to 4 Chapter Objectives Create an inline view using a multiple- column subquery in a FROM clause Compensate for NULL values in subqueries Distinguish between correlated and uncorrelated subqueries Nest a subquery inside another subquery
Background image of page 4
Chapter 7 Introduction to 5 Subquery Used when query is based on unknown
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/10/2011 for the course CIS339 NONE taught by Professor None during the Spring '10 term at DeVry Chicago.

Page1 / 23

chap07 - Chapter 7 Subqueries Chapter 7 Introduction to 1...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online