oracle的in

1.使用in将值传进来
SELECT
*
FROM
       table_A  a
WHERE
       a.id in ('1001','1002','1003')

2.使用not in过滤不需要的值
SELECT
*
FROM
       table_A  a
WHERE
       a.id not in ('1001','1002','1003')

3.使用in将某一个查询的结果作为值传进来
SELECT
*
FROM
       table_A  a
WHERE
       a.id in (SELECT b.id FROM table_B b WHERE b.levels='0')