Sign inSign in
ConceptSystems & CS

Common table expression

Provides a way to write auxiliary temporary result sets for use within a larger query, acting as an alternative to views and nested queries.
as Andy Pavlo defines itCarnegie Mellon University
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.

Nested queries1SQL1SQL queries1Sub-queries1View1

Lecturers

1

    Connections

    4

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

    Concepts3

    1 lecturer. 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.