Справочник по функциям PostgreSQL

WITH

Определяет общее табличное выражение (CTE).

PostgreSQL 17.5

WITH name_cte AS (subquery)

name_cte

Имя CTE

subquery

Подзапрос

Примеры

PostgreSQL 17.5

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