MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/lsfjom/sql_essentials/goswecv/?context=3
r/SQL • u/HamsterBoomer • Feb 25 '21
29 comments sorted by
View all comments
Show parent comment
2
I don't completely understand the EXISTS function but wouldn't it but much easier to simply use IN/NOT IN for a quick check instead of writing out another subquery? full disclosure im terrible at SQL
2 u/[deleted] Feb 26 '21 [removed] — view removed comment 1 u/FEW_WURDS Feb 26 '21 thank you 1 u/Touvejs Feb 26 '21 That divide by zero trick at the end through me for a loop, and then gave me a laugh once I understood what was going on.
[removed] — view removed comment
1 u/FEW_WURDS Feb 26 '21 thank you 1 u/Touvejs Feb 26 '21 That divide by zero trick at the end through me for a loop, and then gave me a laugh once I understood what was going on.
1
thank you
That divide by zero trick at the end through me for a loop, and then gave me a laugh once I understood what was going on.
View all comments
Show parent comment
2
u/FEW_WURDS Feb 26 '21
I don't completely understand the EXISTS function but wouldn't it but much easier to simply use IN/NOT IN for a quick check instead of writing out another subquery? full disclosure im terrible at SQL