common-table-expression tutorials

Visiting a directed graph as if it were an undirected one, using a recursive query

Jan 18, 2021

PostgreSQL - CTE upsert returning modified rows

Sep 07, 2022

sql postgresql postgresql-9.1 common-table-expression upsert

SQL Server MERGE + Joining other tables

Mar 05, 2017

sql-server tsql merge common-table-expression sql-merge

recursive path aggregation and CTE query for top-down tree postgres

Aug 19, 2022

postgresql common-table-expression recursive-query

Why does a Recursive CTE in Transact-SQL require a UNION ALL and not a UNION?

Oct 12, 2022

sql-server tsql recursion common-table-expression

Detect duplicate items in recursive CTE

Feb 08, 2022

sql postgresql common-table-expression

hierarchical sum in PostgreSQL

Oct 22, 2022

sql postgresql common-table-expression

How to use CTE's with update/delete on SQLite?

May 20, 2019

sql sqlite sql-update common-table-expression

CTE and FOR XML to generate nested XML

Mar 30, 2022

sql-server xml tsql common-table-expression for-xml

Why Oracle connect by with nocycle follows root cycle

Nov 13, 2022

sql oracle11g hierarchy cycle common-table-expression

Why do Recursive CTEs run analytic functions (ROW_NUMBER) procedurally?

Nov 13, 2022

sql sql-server common-table-expression row-number recursive-cte

Postgres CTE : type character varying(255)[] in non-recursive term but type character varying[] overall

Feb 10, 2022

postgresql graph-theory common-table-expression

Bizarre performance issue: Common Table Expressions in inline User-Defined Function

Sep 24, 2022

sql-server performance sql-server-2008 user-defined-functions common-table-expression

PostgreSql -> CTE + UPDATE + DELETE -> not expected result, why?

Apr 18, 2022

postgresql common-table-expression

Best Way to Store/Access a Directed Graph

Aug 16, 2022

rdbms common-table-expression directed-graph

What is the advantage of common table expression in sql server

Oct 17, 2022

sql sql-server tsql common-table-expression

SQL Server: How to limit CTE recursion to rows just recursivly added?

Jul 18, 2017

sql-server common-table-expression

postgresql update multiple tables in single query

Dec 28, 2021

sql postgresql sql-update common-table-expression

Remove duplicate sub-query

Oct 22, 2022

sql sql-server tsql common-table-expression dynamic-sql

CTE, ROW_NUMBER and ROWCOUNT

Oct 24, 2022

sql sql-server common-table-expression row-number rowcount

New posts in common-table-expression