Chapter 9 Supplemental Slides - PowerPoint PPT Presentation
1 / 6
Title:
Chapter 9 Supplemental Slides
Description:
Title: Chapter 9 Supplemental Slides II (University Database) Subject: Type II Nested Query Demonstration Author: Michael Mannino Last modified by – PowerPoint PPT presentation
Number of Views:82
Avg rating:3.0/5.0
Title: Chapter 9 Supplemental Slides
1
Chapter 9 Supplemental Slides
Type II Nested Query Demonstration
2
Type II Nested Query Animation
SELECT FacSSN, FacLastName, FacDept FROM
Faculty WHERE NOT EXISTS ( SELECT FROM
Student WHERE Student.StdSSN
Faculty.FacSSN )
3
Type II Nested Query Animation
4
Type II Nested Query Animation
Result
FacSSN
FacLastName
FacRank
5
Type II Nested Query Animation
Result
FacSSN
FacLastName
FacRank
098
-
76
-
5432
VINCE
ASST
6
Type II Nested Query Animation
Result
