Query Rewriting: Subqueries, CTEs, Joins, Window Functions March 26, 2026 15 min read Learn when to use subqueries vs joins vs CTEs, effective CTE patterns, IN vs EXISTS, OR to UNION rewrites, and avoiding SELECT *. #database #sql #query-optimization #cte #window-functions #subqueries