Menu

1 / 2

SQL Subqueries vs CTEs

DEV Community·Venus-Kennedy·7 months ago
#jg8xs1Lb
#beginners#database#sql#tutorial#select
Reading 0:00
15s threshold

Ever written a query… And halfway through forgot what you were doing?

You start simple:

SELECT * FROM books;

Then suddenly you're nesting queries inside queries…

Adding conditions inside conditions…

And now your SQL looks like a maze you can’t escape.

That’s exactly where Subqueries and CTEs (Common Table Expressions) come in.

Let’s break them down.

What is a subquery?

A subquery is just a query inside another query.

Think of it like this:

“Get me results… based on another result.”

It runs first, then feeds its result into the main query.

Example: Find books priced above average

SELECT title, price

FROM books

WHERE price > (SELECT AVG(price) FROM books);

What’s happening here:

The inner query calculates the average price

The outer query filters books above that value

* When Should You Use Subqueries?

*

Subqueries are perfect when you want to:

Filter data using another query

Compare values dynamically

Avoid writing multiple separate queries

Keep logic compact

* Types of…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.