Sign inSign in
ConceptSystems & CS

Nested queries

A query inside another SQL query, allowing the result of an inner query to be used as a condition for an outer query.
Watch it explained

Know first

Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.

Select statement1SQL select statements1WHERE clauses1

Opens up

Concepts that name this one as a prerequisite.

Lecturers

2

Each in their own terms, from the easiest level.

  • Andy Pavlo

    Carnegie Mellon University · Undergraduate

    A query invoked inside of another query to compose more complex computations, often called subqueries.
    • 56:07Modern SQL — Window Functions, CTEs & Bag Semantics

Connections

8

The lectures that define it or assume it, and the concepts next to it.

Concepts6

Lectures2

2 lecturers. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.