Why You Should Love Common Table Expressions (CTE's) | Essential SQL

Watch this video to see common table expressions in action. Want to learn more SQL tips? Check out my guide "How to Code SQL like a Boss" at https://www.essentialsql.com/codeboss We'll use a common table expression to find sales orders containing the top 3 most expensive products. I'll go through a use case showing how the results from the CTE are used in subsequent query. You'll see that the CTE make the query much easier to read. This query could have been done using Subqueries, but what's the fun with that? Let's learn new stuff! Click here to learn more about my exciting new program FearlessSQL! https://www.essentialsql.com/go?utm_medium=youtube&utm_source=youtube&utm_campaign=FearlessSQLPreLaunch&utm_content=video