@vyvianspipes
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 🙂
@bagindamirza
much thanks for your video! great explanation on this topic!
@hadibq
Very nicely explained 👍TY
@kc123456789101112
Finally, someone answered the nagging question in my head, "Why not just use a join?" Thanks Doug!
@yeoshuabenzaken7736
in the first example (select 17) the exists is acting like a Boolean since the subquery is true so it brings everything in the outer query but in the 2nd example (the correlated query) exists is acting like "in" . how is that?
@sergeykurk
i don't understand. in the first example we get ALL CategoryNames from Categories if there is at least one row in subquery ? or only CategoryNames that have products?
@z40140110
Thank you very much for such great content.
@MethodOverRide
Fantastic video and exactly what I needed!
@adreamer9999
Thank you for the explanation. Very helpful.
@babybob8823
Very clear and to the point. Thanks a lot.
@voodoochili12
Great explanation, thank you
@VincenzoCorvaglia
Very good explanation. Tank you so much!
@VeronicaAngryPolak
this was awesome
@bruville
Very good explanation! Thanks!
@aspanon1560
Thanks a lot. What does the query return if WHERE EXISTS returns false?
@abdulsami1982
can we use where exists. or where not exists with insert query ?
@gbting1988
Thx for the explanation. Do you mean exist will dedup and same with IN statement it will dedup too?
@r0cketRacoon
in subquey, can I select * or any random columns ? does it have to follow any patterns of select in subquery?
@debayan89
It cleared my doubts. Very very helpful.
@adrianpatino5166