背景,需要把SQL脚本的in语句转换成exists语句,原来的条件是
where A.area in('01','02'....) ,
现在想把句句转换成exists的..
问题是把下面这语句,变成只有一个字段的就可以了,请问怎么写呢???
select '01',
'04',
'06',
'08',
'10',
'12',
'13',
'14',
'16',
'17',
'19',
'21',
'23',
'24',
'25',
'26',
'27',
'28',
'29' from dual
where A.area in('01','02'....) ,
现在想把句句转换成exists的..
问题是把下面这语句,变成只有一个字段的就可以了,请问怎么写呢???
select '01',
'04',
'06',
'08',
'10',
'12',
'13',
'14',
'16',
'17',
'19',
'21',
'23',
'24',
'25',
'26',
'27',
'28',
'29' from dual
select '01' as areaid from dual
union
select '04' from dual
union
select '06' from dual
union
select '08' from dual
union
select '10' from dual
union
select '12' from dual
union
select '13' from dual
union
select '14' from dual
union
select '16' from dual
union
select '17' from dual
union
select '19' from dual
union
select '21' from dual
union
select '23' from dual
union
select '24' from dual
union
select '25' from dual
union
select '26' from dual
union
select '27' from dual
union
select '28' from dual
union
select '29' from dual
)但这种写法语句太长了,有没有办法不这样写