BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

517Scalar subqueries
518Scalar subquery cardinality errors
519Row subqueries
520Table subqueries in FROM
521Derived table aliases
522Subqueries in SELECT lists
523Correlated subqueries
524Correlated subquery performance
525IN subqueries
526NOT IN subqueries
527EXISTS subqueries
528NOT EXISTS subqueries
529ANY subquery comparisons
530SOME subquery comparisons
531ALL subquery comparisons
532Subquery decorrelation
533Subquery flattening by the planner
534Comparing employees with department averages
535Finding products above category median price
536Selecting rows with maximum values per group
537WITH clause basics
538Multiple CTEs in one statement
539CTE column lists
540CTE scope and visibility
541CTEs versus subqueries
542CTEs versus views
543MATERIALIZED CTE hints
544NOT MATERIALIZED CTE hints
545CTE inlining rules
546Data-modifying CTEs
547INSERT in a CTE with RETURNING
548UPDATE in a CTE with RETURNING
549DELETE in a CTE with RETURNING
550Moving rows between tables with a CTE
551Refactoring a long report into CTEs
552Naming CTEs for reviewability
553CTE optimization fences
554SEARCH clause in recursive CTEs
555CYCLE clause in recursive CTEs
556WITH RECURSIVE structure
557Anchor member and recursive member
558UNION ALL versus UNION in recursion
559Recursive termination conditions
560Generating number series recursively
561Employee manager hierarchies
562Bill-of-materials explosion
563Category tree path construction
564Depth tracking in recursion
565Breadth-first ordering with SEARCH BREADTH FIRST
566Depth-first ordering with SEARCH DEPTH FIRST
567Array path accumulation
568Cycle detection with path arrays
569Cycle marking with CYCLE
570Shortest path in an unweighted graph
571Recursive reachability in flight routes
572Finding ancestors and descendants
573Calculating cumulative totals recursively
574Recursive CTE memory and work_mem
575Recursive CTE limitations
576Fibonacci sequence recursion
577Dependency resolution for software packages
578Comment thread flattening
579Transitive closure of access groups

Databases & SQL

517Scalar subqueries
518Scalar subquery cardinality errors
519Row subqueries
520Table subqueries in FROM
521Derived table aliases
522Subqueries in SELECT lists
523Correlated subqueries
524Correlated subquery performance
525IN subqueries
526NOT IN subqueries
527EXISTS subqueries
528NOT EXISTS subqueries
529ANY subquery comparisons
530SOME subquery comparisons
531ALL subquery comparisons
532Subquery decorrelation
533Subquery flattening by the planner
534Comparing employees with department averages
535Finding products above category median price
536Selecting rows with maximum values per group
537WITH clause basics
538Multiple CTEs in one statement
539CTE column lists
540CTE scope and visibility
541CTEs versus subqueries
542CTEs versus views
543MATERIALIZED CTE hints
544NOT MATERIALIZED CTE hints
545CTE inlining rules
546Data-modifying CTEs
547INSERT in a CTE with RETURNING
548UPDATE in a CTE with RETURNING
549DELETE in a CTE with RETURNING
550Moving rows between tables with a CTE
551Refactoring a long report into CTEs
552Naming CTEs for reviewability
553CTE optimization fences
554SEARCH clause in recursive CTEs
555CYCLE clause in recursive CTEs
556WITH RECURSIVE structure
557Anchor member and recursive member
558UNION ALL versus UNION in recursion
559Recursive termination conditions
560Generating number series recursively
561Employee manager hierarchies
562Bill-of-materials explosion
563Category tree path construction
564Depth tracking in recursion
565Breadth-first ordering with SEARCH BREADTH FIRST
566Depth-first ordering with SEARCH DEPTH FIRST
567Array path accumulation
568Cycle detection with path arrays
569Cycle marking with CYCLE
570Shortest path in an unweighted graph
571Recursive reachability in flight routes
572Finding ancestors and descendants
573Calculating cumulative totals recursively
574Recursive CTE memory and work_mem
575Recursive CTE limitations
576Fibonacci sequence recursion
577Dependency resolution for software packages
578Comment thread flattening
579Transitive closure of access groups

← Databases & SQL

Search the Databases & SQL glossary

Lesson 519 of 2,478·9. Subqueries, CTEs, and RecursionFree lesson

Row subqueries

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy