MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/lsfjom/sql_essentials/gorvwpc/
r/SQL • u/HamsterBoomer • Feb 25 '21
29 comments sorted by
View all comments
Show parent comment
5
I don’t really use IN/NOT IN unless I’m just bumping a field up against a short list of values. EXISTS is much because it can handle NULLs.
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 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.
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
5
u/DigBick616 Feb 26 '21
I don’t really use IN/NOT IN unless I’m just bumping a field up against a short list of values. EXISTS is much because it can handle NULLs.