sql在指定数字中筛选（这次执行是oracle）

例子：在1,2,3,4,5中筛选不包含1,3,4,5的数字是  2

 

 

 

 

 

 

 

 

结果如截图

 

select ROUTE_NUMBER_I  from 
(select 1 ROUTE_NUMBER_I from dual
union all 
select 2 ROUTE_NUMBER_I from dual
union all 
select 3 ROUTE_NUMBER_I from dual
union all 
select 4 ROUTE_NUMBER_I from dual
union all 
select 5 ROUTE_NUMBER_I from dual) a