The SQL EXISTS clause

much thanks for your video! great explanation on this topic!

Finally, someone answered the nagging question in my head, "Why not just use a join?" Thanks Doug!

this was awesome

Very nicely explained 👍TY

exists are not for beginners xD

Doug, you have helped me tremendously! When the part about NOT EXISTS was explained, this in itself shed light onto the exact problem I needed to mitigate. Thank you 🙂

Very good explanation. Tank you so much!

That is very helpful

Thank you very much for such great content.

love it

you the MAN!

Thank you Sir.

Fantastic video and exactly what I needed!

Thank you for making it understandable.

Very clear!

Good video!

May I ask you why Joins are more popular than the Exists clause? At least when I go to interviews or I speak to people they always ask me about Joins but never about the Exists clause

Thx for the explanation. Do you mean exist will dedup and same with IN statement it will dedup too?

Very good explanation! Thanks!

Thanks a lot. What does the query return if WHERE EXISTS returns false?