Query IDs that do not exist in the Database

Query the IDs that do not exist in the Database. Suppose your database has A table A: www.2cto.com ID NAME1 aaa2 bbb3 ccc4 ddd requirement: How many IDs do you need to return the IDs that do not exist in Table? The following code returns. 1.,. select id from A where A. ID in. 2. now we use an SQL statement: www.2cto.com SQL code select B. id from (select 1 as id from dual union select 2 as id from dual union select 8 as id from dual union select 9 as id from dual) B left join A on. id = B. id where. id is null;