SELECT * FROM
(SELECT * FROM B WHERE (B.ID>(SELECT MAX(ID) FROM A )) ORDER BY ID )
WHERE ROWNUM = 1;
这样选出id=6的记录
SELECT * FROM
(SELECT * FROM B WHERE (B.ID<=(SELECT MAX(ID) FROM A )) ORDER BY ID DESC)
WHERE ROWNUM = 1;
这样选出id=4的记录
如果两条都要,则联合上面两条语句SELECT * FROM
(SELECT * FROM B WHERE (B.ID>(SELECT MAX(ID) FROM A )) ORDER BY ID )
WHERE ROWNUM = 1
UNION
SELECT * FROM
(SELECT * FROM B WHERE (B.ID<=(SELECT MAX(ID) FROM A )) ORDER BY ID DESC)
WHERE ROWNUM = 1;
(SELECT * FROM B WHERE (B.ID>(SELECT MAX(ID) FROM A )) ORDER BY ID )
WHERE ROWNUM = 1;
这样选出id=6的记录
SELECT * FROM
(SELECT * FROM B WHERE (B.ID<=(SELECT MAX(ID) FROM A )) ORDER BY ID DESC)
WHERE ROWNUM = 1;
这样选出id=4的记录
如果两条都要,则联合上面两条语句SELECT * FROM
(SELECT * FROM B WHERE (B.ID>(SELECT MAX(ID) FROM A )) ORDER BY ID )
WHERE ROWNUM = 1
UNION
SELECT * FROM
(SELECT * FROM B WHERE (B.ID<=(SELECT MAX(ID) FROM A )) ORDER BY ID DESC)
WHERE ROWNUM = 1;
解决方案 »
- 为什么oracle定时任务启动不了呢? 如有满意答案---速结贴给分~<>~
- oracle中关于for循环循环游标问题
- oracle视图中sum函数的问题
- Oracle中用SQL插入数据时,主键值如何设置为插入数据中的主键值
- IMP导入问题,000069,急!!!
- oracle性能优化,SQL语句全优化,SQL语句执行效率问题的等深度分析文档
- ORACLE 存储过程问题(大家给些建议)
- Oracle ODBC驱动
- 重新开放ftp,已有资料20GB
- 请问:在windows下装的oracle怎么建立个新用户啊?
- 找ORACLE同行合租
- 为什么用用户登陆会出现:访问 PRODUCT_USER_PROFILE 时出现错误?
where b.id-aa.id in
(
select min(b.id-aa.id) from b,(select max(id) id from a) aa where b.id>aa.id
union
select max(b.id-aa.id) from b,(select max(id) id from a) aa where b.id<aa.id
);