rownum不支持“>”操作,用minus
select * from employee_test
where id like '%id%' order by sort
and rownum <= 8
minus
select * from employee_test
where id like '%id%' order by sort
and rownum <= 4;
select * from employee_test
where id like '%id%' order by sort
and rownum <= 8
minus
select * from employee_test
where id like '%id%' order by sort
and rownum <= 4;
解决方案 »
- ORACLE或者hibernate高手快来哦。。。。
- 请教高手--如何计算除去星期天的小时数!!
- 我想取一整条数据,可是我写的游标只能一个字段一个字段的取,求教,怎么解决.(邹建来吧)
- 请教LINUX下ORACLE的恢复问题?
- ERROR 位于第 1 行:ORA-00933: SQL 命令未正确结束
- 10G与9I之间的数据转换?
- 两个日期相减得到不是整数,我想把结果用round四舍五入,但提示需要number类型,请问如何把日期相减得到的数转换成
- pl/sql dev 中test window 和 sql window编写脚本有什么差别???
- dblink语句,在线等!!!!
- oracle 怎么跨用户更新数据?
- 为什么这几句代码执行不了?
- 请教有 ORACLE 数据库的启动问题?
改成这样:
select * from (select rownum id,employee.* from (select * from employee_test where id like '%id%' order by sort)
where id <= 8
)
where
id >= 4;