# 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)…
DevOps
⚑ Report a ProblemLatest DevOps news from Tech News
All topics
agents
ai
api
architecture
automation
aws
backend
beginners
cloud
database
devchallenge
devops
docker
javascript
kubernetes
llm
machinelearning
mcp
node
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…