#setoperations — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #setoperations, aggregated by home.social.
-
INTERSECT vs INNER JOIN?!
INTERSECT and INNER JOIN are DIFFERENT! INTERSECT removes duplicates, JOIN doesn't. Same data, different results. This will break your logic!
#sql #sqltricks #intersect #innerjoin #setoperations #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #joins #advancedsql
-
UNION ALL Preserves Duplicates?!
UNION ALL keeps ALL rows! UNION removes duplicates. This one keyword difference changes the entire result set. This will break your data!
#sql #sqltricks #union #unionall #duplicates #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #setoperations #advancedsql
-
NOT IN With NULL Returns FALSE Always?!
NOT IN with NULL in the list ALWAYS returns FALSE! Even if value is not in list, NULL breaks NOT IN logic completely! Watch!
#sql #sqltricks #database #sqltutorial #notin #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #setoperations #sqlwtf
-
EXCEPT vs NOT EXISTS?!
EXCEPT removes rows from first set! It's like subtraction for result sets. NOT EXISTS does similar but differently. This set operation will confuse you!
#sql #sqltricks #except #notexists #setdifference #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #setoperations #advancedsql
-
DISTINCT With Multiple NULLs?!
DISTINCT treats all NULLs as the same value! Multiple NULLs become one. This breaks uniqueness logic. Watch the reveal!
#sql #sqltricks #database #sqltutorial #distinct #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #setoperations #sqlwtf