select * from tab
order by 1
我想查询前20个 用top怎么用呀
order by 1
我想查询前20个 用top怎么用呀
解决方案 »
- ORA-28547 如何解决?
- oracle 在xp系统下的安装问题,请高手指导下!!!跪求!!!
- 我建立了一个用户,为什么在"方案"中没有找到这个名字?
- 运行速度不快的oracle数据库的解决方案?
- 如何在linux上自动备份oracle数据库,备份后,自动把备份文件拷到磁带机上。
- 求:ORACLE开发教程 电子版 中英文都可以
- 关于一个简单的sql语句,请进来帮忙
- 关于日志和回滚段的简单问题???
- sql SERVER语句和oracle里sql语法的转换!!
- 数据库迁移的问题
- imp导入操作进行到一半ctrl+C退出,下步该怎么?
- oracle初学。建立不同名称的两个全局数据库,用相同的表空间名和用户名。
oracle中利用rownum去实现
select * from (select tab.*,rownum rn from tab order by col) where rn<=20 order by col;
select * from (select tab.*,rownum() over (order by col) rn from tab) where rn<=20 order by col;
(select *,rownum rn from tab
order by 1 ) a
where a.rn <= 20
oracle:
select * from
(select * from table order by .. desc)
where rownum<21
SELECT *
FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY 1) ROWC FROM TAB)
WHERE ROWC <= 20;
SELECT * FROM (SELECT uo.*,dense_rank() over(order by rownum) rank FROM user_objects uo) WHERE rank<21;
SELECT * FROM TAB WHERE ROWNUM<=20
觉得特别,但不太清楚rank用法,学习一下
SELECT * FROM (SELECT id from bb order by id) where rownum <3;取第M条到第N条之间的
select *
from (select id,name,row_number() over(order by id) rn
from user) t
where t.rn>=4 and t.rn <=6删除M条到第N条之间的记录
delete from tb1 where rowid in
(SELECT rowid FROM (SELECT rowid,id,VAL,row_number() over (order by VAL) rn from TB1 )
where rn >2 and rn<6);
select * from tab where rownum>=10为啥不行啊
select top(20),* from tab order by col;