From the course: Advanced SQL: High Performance Relational Divisions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Exact relational division - SQL Tutorial
From the course: Advanced SQL: High Performance Relational Divisions
Challenge: Exact relational division
- [Instructor] Surprise, surprise. Your challenge for this chapter is to come up with an exact relational division. This time, using nested subqueries. We need to find candidates who fit the DB Architect role, and eliminate those who are overqualified. Can you show Darrin the way out? You are not allowed to use neither aggregates, nor set operators, only double negative and nested subqueries this time. If you follow the same guidelines as the previous challenges, and remember that an exact division is just an ordinary relational division with an additional constraint sprinkled on top, you should be able to tackle this one. Good luck.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.