PostgreSQL Funktionsreferenz

WITH

Definiert einen Common Table Expression (CTE).

PostgreSQL 17.5

WITH name_cte AS (subquery)

name_cte

Der CTE-Name

subquery

Die Unterabfrage

Beispiele

PostgreSQL 17.5

WITH family_stats AS (
	SELECT STATUS,
		COUNT(*) AS cnt
	FROM FamilyMembers
	GROUP BY STATUS
)
SELECT *
FROM family_stats;