SQL - CTE (WITH)

Overview

CTEs define a named result set for reuse in a single statement. They improve readability and can be recursive.

WITH top_paid AS (
  SELECT first_name, salary FROM employees ORDER BY salary DESC LIMIT 5
)
SELECT * FROM top_paid;

WITH top_paid AS (
  SELECT TOP (5) first_name, salary FROM employees ORDER BY salary DESC
)
SELECT * FROM top_paid;

WITH top_paid AS (
  SELECT first_name, salary FROM employees ORDER BY salary DESC LIMIT 5
)
SELECT * FROM top_paid;