试一试
select B.id from B, A
where A.income between B.begin and B.end;
select B.id from B, A
where A.income between B.begin and B.end;
解决方案 »
- 数据导入错误:IMP-00017: following statement failed with ORACLE error 2299 请高手指点迷津
- Toad 跟踪应用程序SQL 问题!
- oracle字符串中文内容替换的问题!
- (ora-06502 pl sql 数字或值错误 字符串缓冲区太小)(ORA-03127 no new operations allowed until ..)
- Oracle 中如何创建一个序列 001,002……999
- VMware虚拟机问题
- 怎样设置每月1号凌晨0:00执行job?
- 怎么查已经装好的oracle8.05的SID?
- 这条语句怎么写?
- 数据库报错,各位达人帮忙看看是什么错误引起的!
- PLSQL动态创建表的问题
- copy from 的问题
begin end id
1 10 1
11 20 2
21 30 3
30 100 9
A表:
income
8
25
13
50
这是两个表的数据,现在我要根据A表的数据从A表得到id ,现在清楚吗?
where begin > (select min(income) from a)
and end < (select max(income) from a)
SQL> select * from b; BEGIN END ID
---------- ---------- ----------
11 20 2
1 10 1
21 30 3SQL> select * from a; INCOME
----------
8
25
13
SQL> select id from b,a where a.income between b.begin and b.end; ID
----------
1
3
2
SELECT ID FROM B
MINUS
SELECT ID FROM B WHERE B.begin < select min(income) from a
MINUS
SELECT ID FROM B WHERE B.end > select max(income) from a