请问：怎样在oracle数据库中查出最后10列数据出来按正序排列？

[ManOfBCB]

如题.

[ATCG]

题意不清，按照什么排序啊？是最后10行吧？

[skystar99047]

是最后10行数据吧.
select * from(select col1,col2,...,rownum as con from tablename) where rownum>(select count(*)-10 from tablename);
已通过调试。

[benxie]

gzing

[cantail]

select * from
(select * from (select * from mstbmn order by rownum desc)
where rownum <11 order by rownum asc)
order by rownum desc

[ManOfBCB]

con好象没用啊？大哥，可不可以给我讲讲rownum的含义阿？谢谢

[ManOfBCB]

哦，搞错了，是最后10行数据，按一个关键字排序

[ManOfBCB]

如果是n行呢？

[oracs]

select * from
(select ID from Table1 order by rownum desc) a
where rownum <=10;

[ManOfBCB]

rownum可以吗？

[ManOfBCB]

没有人了吗？

[msdn_vipuser]

试试skystar99047(天星)的方法

[ManOfBCB]

还是不理想啊！

[chanet]

SELECT *
FROM (SELECT *
FROM tab
ORDER BY tname DESC)
WHERE ROWNUM <= 10 ORDER BY tname ASC;

ROWNUM 就是行数的意思.(Oracle 关键字)

方法: 先按降排序,然后取 前10个 再按升排序.

[jjz2004]

select * from(select empno,ename,rownum as con from emp order by empno desc)
where rownum<=10 order by empno asc;
这个没问题
已调试