T-SQL by Example

🚧 CTEs

🚧 Coming soon: Encapsulate subqueries, improve readability, and use recursion for hierarchies.

-- Placeholder example
WITH RecentOrders AS (
  SELECT TOP (100) * FROM dbo.Orders ORDER BY OrderDate DESC
)
SELECT * FROM RecentOrders;