select sname
from table1
where snumber in
(select snumber2 from table2 where sname2 = 'xiao')
or snumber in
(select snumber3 from table2 where sname2 = 'xiao')
or snumber in
(select snumber4 from table2 where sname2 = 'xiao')
or snumber in
(select snumber5 from table2 where sname2 = 'xiao')
or snumber in
(select snumber6 from table2 where sname2 = 'xiao')
or snumber in
(select snumber7 from table2 where sname2 = 'xiao')
如何将上面的语句写的简洁,正确。
主要内容是: 检测 table1中snumber字段是否与table2中(snumber2到snumber7中)任意一个字段匹配。
from table1
where snumber in
(select snumber2 from table2 where sname2 = 'xiao')
or snumber in
(select snumber3 from table2 where sname2 = 'xiao')
or snumber in
(select snumber4 from table2 where sname2 = 'xiao')
or snumber in
(select snumber5 from table2 where sname2 = 'xiao')
or snumber in
(select snumber6 from table2 where sname2 = 'xiao')
or snumber in
(select snumber7 from table2 where sname2 = 'xiao')
如何将上面的语句写的简洁,正确。
主要内容是: 检测 table1中snumber字段是否与table2中(snumber2到snumber7中)任意一个字段匹配。
解决方案 »
- [Help]请教Oracle 8g/9g数据库连接字符串问题。。。
- 查询a,b,c三个表的一些字段 可是b表需要UNION ALL b的历史表 可以实现吗?
- 大数据量sql怎么优化
- 计划任务中如何使用每季度执行一次?
- oracle数据库导出和导入
- Oracle(10G)无法建立监听(用sqlplus正常),怎么办?
- TOAD9.6版本的问题
- 能不能实现这个功能?(立即结贴)
- 求条sql语句,
- 帮忙看看哪里出错了?谢谢
- SQL Developer工具
- 救命级求救:“OCI-21500: internal error code, arguments: [17099], [], [], [], [], [], [], []” 如何解决?
from table1 A,table2 B
where B.sname2='xiao' and (A.snumber=B.snumber2 or
A.snumber=B.snumber3 or
A.snumber=B.snumber4 or
A.snumber=B.snumber5 or
A.snumber=B.snumber6 or
A.snumber=B.snumber7 )
'xiao' and decode(a.snumber,b.snumber2,1,b.sumber3,1,
b.snumber4,1,b.snumber5,1,b.snumber2,1,b.snumber6,1,
b.snumber7,1)=1
select a.sname from table1 a
inner join table2 b
on b.sname2='xiao' and (a.snumber=b.snumber2 or
a.snumber=b.snumber3 or
a.snumber=b.snumber4 or
a.snumber=b.snumber5 or
a.snumber=b.snumber6 or
a.snumber=b.snumber7)用inner join 在理论上是否比你的效率要高些啊?