oracle 怎么查最后100行数据

[luck5]

from tablea where rownum<100
这是取前100行，可如何取出最后的100行，

[超叔csdn]

select a.* from
(select tablea.*,rownum r from tablea ) a,(select count(*) as cn from tablea) b
where a.r<=b.cn and a.r>b.cn-100

[Hangfeng]

select * from
(select rowid id,a.* from table a order by id desc)
where rownum<=100

[Hangfeng]

上面错了,应该是
select * from
(select rownum rn,a.* from table a order by rn desc)
where rownum<=100

[wgsasd311]

select * from
(select * from tb order by rownum desc)
where rownum<100;

[luck5]

这样显示的数据是倒顺序的

[pobaby]

select * from ( select * from table a order by rowid desc) where rownum<=10;

[ygc8163]

select * from tablename where rowid in (select rowid from tablename where rownum <=100 order by rowid desc) order by rowid asc

[ygc8163]

select * from tablename where rowid in (select rowid from tablename where rownum <=100 order by rowid desc) order by rowid asc

tablename 为表名，
rowid 换成你表中用于排序的关键字
rownum 是oracle内置的关键字，用于查询多少条纪录