with temp as 使用

with temp1 as (select * from  TEST_NOT_DELETE  where id='1')
     ,temp2 as (select * from  TEST_NOT_DELETE  where id='2')
     
select *  from  TEST_NOT_DELETE  t 
where t.id  in (select id from temp1 union select id from temp2)

同级sql中只能有一个with，一个with 可以有多个子查询，即使：可以有多个临时表，用,分隔开即可

作用及好处：https://blog.csdn.net/rosanu_blog/article/details/8288548