CTE SQL

WITH cte_name AS (
    SELECT column1, column2
    FROM table_name
    WHERE conditions
)
SELECT *
FROM cte_name;

WITH geek_cte AS (
    SELECT 'geek-docs.com' AS website
)
SELECT *
FROM geek_cte;

| website        |
|----------------|
| geek-docs.com  |

WITH cte1 AS (
    SELECT 'geek-docs.com' AS website
),
cte2 AS (
    SELECT 'SQL' AS topic
)
SELECT *
FROM cte1
JOIN cte2 ON 1=1;

| website        | topic |
|----------------|-------|
| geek-docs.com  | SQL   |

WITH RECURSIVE employee_cte AS (
    SELECT employee_id, employee_name, manager_id
    FROM employee
    WHERE manager_id IS NULL
    UNION ALL
    SELECT e.employee_id, e.employee_name, e.manager_id
    FROM employee e
    JOIN employee_cte ecte ON e.manager_id = ecte.employee_id
)
SELECT *
FROM employee_cte;

WITH cte AS (
    SELECT website
    FROM websites
    WHERE website = 'geek-docs.com'
)
UPDATE cte
SET website = 'example.com';