Database management systems notes
Subqueries
Queries inside queries, including the two that express "all" and "none". Every section is a drawn page beside a clear written explanation, about 20 minutes in all.
- Chapter 11 of 34
- About 20 minutes
- 8 sections
Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.
In this chapter
- Scalar subqueries: one value
- IN and NOT IN: a column of values
- Correlated subqueries
- EXISTS: does any row come back?
- ANY and ALL
- Subqueries in FROM: derived tables
- Division: "all of them"
- Choosing between join, subquery and EXISTS
Next chapters
Read the whole chapter
Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.
DSA comes with the all labs plan and every ChaiCode batch.