Advanced SQL Techniques - CTE

A Common Table Expression (CTE) is a temporary, named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. Think of it as a temporary view that exists only for the duration of a single query, making complex queries ...