in和exists区别

in 的用法：
SELECT *
  FROM AS_EMP A
 WHERE a.emp_code NOT IN (SELECT t.emp_code FROM TEST_EXISTS T );


exists 的用法：
SELECT *
  FROM AS_EMP A
 WHERE  NOT exists (SELECT 'x' FROM TEST_EXISTS T where t.emp_code = a.emp_code);