如果是8i
select * from (
select rownum id,t.* from table t order by 工资) a
where a.id>4
and
rownum<=1
select * from (
select rownum id,t.* from table t order by 工资) a
where a.id>4
and
rownum<=1
解决方案 »
- ORACLE从多个关联的表中随机取20条数据
- oracle10g plsql Developer 导出.sql文件后,注释是乱码
- 如何查找删除记录的历史
- oracle中使用视图的好处
- 如何在本机即安装服务器(8i)又安装Developer开发工具(form builder、report builder)!
- 此SQL如何写?
- 无法为表空间ttt中的段创建ini区
- 征求一下大家对倒分的处理意见
- 怎样联数据库,给分
- 求教:只知道system/manager@dbserver这个用户帐号,怎么才能打开别的用户下面的表?
- 请教各位高手如何在SQL中给NULL赋值
- “只取一瓢”大哥快来帮我看一下这个SQL语句能不能实现。
where rownum<5
order by 工资;
select username, salary from
(select rownum id, username, salary from
(select * from test_y order by salary desc) where rownum<=5) a where a.id=5;
select * from (
select rownum id,t.* from table t order by 工资 desc) a
where a.id>4
and
rownum<=1
select * from emp
where sal=(
select sal from (select rownum id, a.* from (select distinct sal from emp order by sal desc) a) where id=5);
另外如果第五的概念,包括相同工资在内的话,可以把distinct去掉
select * from emp
where sal=(
select sal from (select rownum id, a.* from (select sal from emp order by sal desc) a) where id=5);