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中)任意一个字段匹配。
解决方案 »
- sqlplus添加字段出错
- oracle 的逻辑类型是
- 统计表设计问题
- SOS!监听程序当前无法识别
- oracle中for的问题
- 一条语句总是执行不完,大家帮忙分析~谢谢!
- 请问为什么不执行到while循环里面去呢?
- 急求答案,关于ORACLE存储过程的问题
- oracle中存放有格式的文本内容的时候用什么数据类型?
- 请问如何在VC下使用OCI访问Oracle,如何做,请大虾指点一二。
- 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 在理论上是否比你的效率要高些啊?