# Subqueries & CTEs: Two Ways to Query Inside a Query
Sometimes one query needs the result of another query to work. SQL gives you two main tools for that: subqueries and CTEs (Common Table Expressions)…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
testing
tutorial
typescript
webdev
Recursive CTEs, explained from first principles
Some data isn't flat. An employee has a manager, who has a manager, who has a manager, all the way up to the boss at the top. A comment can be a rep…
CTE vs Temporary Tables in SQL: Which One Should You Use?
One of the most common questions I get from developers working with SQL is: Should I use a CTE or create a temporary table? Both solve similar probl…