select * from tablename
minus
select * from tablename
where rownum<(select max(rownum) from tablename)-10;
minus
select * from tablename
where rownum<(select max(rownum) from tablename)-10;
解决方案 »
- oracle连接求助
- 为什么 pl/sql desc 不能用 还有 就是每次create 表老报错 说缺失右括号
- 关于java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriver的求助!!!!!
- 请教exp的特殊导出
- 复合查询问题(多个字段复合)
- 为什么出现ORA-12154:TNS:无法处理服务名
- 在线等 怎么在ORACLE里根据数据库名查询可登陆用户名列表
- 怎样能最快得把WINDOWS下的数据库拷贝到UNIX下,请高手指点!
- 求助?
- sql 语句 ,如何取出相同记录中的第一条记录
- 各位大侠!请教!
- 在IMP時,怎樣修改EXP時USER的默認TABLESPACES?
如果有
select * from (select * from tname order by insert_date desc) where rownum<11;
如果没有,试试
select * from (select t1.*,t1.rowid from t1 order by rowid desc) where rownum<11;
from (select id,rownum as oi from test1) A,
(select max(rownum) as ui from test1) B
where A.oi>B.ui-10;
where rownum<=(select max(rownum) from tablename)-10;
where rownum<=(select max(rownum) from tablename)-10;
这句话编译有错:
ERROR at line 2:
ORA-00933: SQL command not properly ended不知道是语句本身有问题还是我的oracle版本太旧(8.0.6)
select * from tablename
minus
select * from tablename
where rownum<=(select max(rownum)-10 from tablename我的测试:
select * from pmzd
minus
select * from pmzd
where rownum<(select max(rownum)-10 from pmzd)
的确得到最后的10条兰色沸点:你说的是去除最后10条的结果!
select * from tablename
minus
select * from tablename
where rownum<=(select max(rownum)-10 from tablename);我的测试:
select * from pmzd
minus
select * from pmzd
where rownum<=(select max(rownum)-10 from pmzd);
一定要有“=”,否则是11条