Cơ sở dữ liệu - Chapter 9: Supplemental slides type ii nested query demonstration
Query execution: - For each Faculty row, execute nested query on the Student table - Faculty row does not qualify in the result unless it does not match any Student rows.
Bạn đang xem nội dung tài liệu Cơ sở dữ liệu - Chapter 9: Supplemental slides type ii nested query demonstration, để tải tài liệu về máy bạn click vào nút DOWNLOAD ở trên
Chapter 9 Supplemental SlidesType II Nested Query Demonstration Type II Nested Query AnimationSELECT FacSSN, FacLastName, FacDept FROM Faculty WHERE NOT EXISTS ( SELECT * FROM Student WHERE Student.StdSSN = Faculty.FacSSN ) Type II Nested Query AnimationFacultyStudent Type II Nested Query AnimationFacSSN FacLastName FacRank 098-76-5432VINCEASST FacultyStudentResult Type II Nested Query AnimationFacSSN FacLastName FacRank 098-76-5432 VINCE ASST 543-21-0987EMMANUELPROF FacultyStudentResult Type II Nested Query AnimationFacultyStudentResult
Các file đính kèm theo tài liệu này:
chapter09s_rev_4739.ppt
