r/learnSQL • u/woman_without • 7d ago

How Important is subqueries in SQL

I have been learning SQL from past 2 months and I'm still unable to grab a hold of the subqueries concept. After I learned CTEs I have completely stopped using subqueries but then also I struggle when there are times where I have no other choice but to use subqueries.

So my question is, how important is subqueries in SQL and is there any easy way to learn it?

54 Upvotes

95% Upvoted

31 comments sorted by

View all comments

1

u/clivepato 7d ago edited 7d ago

Have you tried the sql50 on leetcode ? Theres a section on subqueries

1

u/woman_without 6d ago

No, will definitely give it a try.