Using CTEs in SQL

SQL Common Table Expressions (CTEs) – Simplify Complex Queries

Make queries readable with WITH

By Sharanmeet Singh••
Tags:SQLCTEWITH Clause

SQL Query Generator

Generate SQL queries for database operations

Try Generator

SQL Common Table Expressions (CTEs)

CTEs (Common Table Expressions) make queries easier to write and read.

Example

WITH SalesByDept AS (
  SELECT department, SUM(amount) AS total_sales
  FROM sales
  GROUP BY department
)
SELECT * FROM SalesByDept WHERE total_sales > 10000;

Why Use CTEs?

  • Improve readability
  • Reuse subqueries
  • Avoid nested SQL

Tip: CTEs can be recursive, making them great for hierarchical data.