We Learn SQL #14 | Correlated subqueries with EXISTS in SQL

We’re going to talk about a new SQL operator named EXISTS, and how we can use it along with correlated subqueries.

Hello, I’m Adrian and this is another video in the series about SQL basics. You already know quite a lot about subqueries in SQL. In the previous video, we introduced correlated subqueries. Expand your arsenal with another SQL operator - EXISTS. Learn how to use them effectively and how to write better and clearer SQL queries.

Regardless of whether you are just starting your adventure with SQL or you are already an advanced user - I recommend our We Learn SQL channel and my short clips on the basics of SQL. I have recorded episodes about SQL JOINs, SQL Group by clause, and many more. Watch them and give them a thumbs up.

👌 Subscribe to our channel and leave a comment!

👌 Do you want to learn SQL? Go to LearnSQL.com and choose the course or track that is best for you!

[stri]

the information is clear but please do not ad music it's very distracting

[shaistachattha]

I find your teaching method very helpful but the music keeps distracting me. Can you please remove the background music? Or at the least keep it very low.

[ank]

I like your videos. They are easy to understand but can you please get rid of the background music. it suppresses what you are saying in the video.

[Sumfinfunny]

great video. Maybe lower the music volume a tad little? Just a suggestion

[mn]

Thanks for the video. Could you please remove the background music and speak a bit louder.

[TheProblembaer]

Hey Content creator, your videos are really great, and thank you. But please, coulde you reupload without music, it distracts me alottt!

[shivamshekhar]

Stumbled upon your Channel today, and I gotta tell these are the simplest SQL videos out here.
Waiting for more stuff!

[anvarichn]

Writing this comment to complaint on too loud music - Hopefully that can be fixed!

[hendrag]

Thank you very much Adrian for this great video which I think the best video regarding the Exists clause.

[bigbeast]

Think the output shown in video for "WHERE NOT EXISTS" is incorrect. It should fetch 2 values instead of 1. It should be "Magical Products" and "Amazing Stuff" as both of them have items less than 1 $

[scottyblesthunter]

the background music is so distracting

[awilson]

sound is too low, can't hear you even on %100 :/

[stickercode]

I couldn't still get it. So, what is the real function of this exists though? If we, let's say remove it from your query sample, what will be fundamentally changed in the result set?

[labibalmahdi]

The background music is badly distracting

[Jimmy_Neutron]

Raise the music so we can’t hear you ❤

[dimasfariznugroho]

please dont stop sharing :)
and also we need indonesian translate language :(