Advertisement
Guest User

Surprising NULL behavior

a guest
Jul 24th, 2014
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.31 KB | None | 0 0
  1. SELECT CASE WHEN NULL NOT IN ('A', 'B')       THEN 1 ELSE 0 END AS a FROM DUAL;
  2. SELECT CASE WHEN NULL     IN ('A', 'B')       THEN 1 ELSE 0 END AS a FROM DUAL;
  3. SELECT CASE WHEN NULL NOT IN ('A', 'B', NULL) THEN 1 ELSE 0 END AS a FROM DUAL;
  4. SELECT CASE WHEN NULL     IN ('A', 'B', NULL) THEN 1 ELSE 0 END AS a FROM DUAL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement