ORACLE的一个小问题~~

[mutou123]

一个表我有100条记录，我想按一个字段排序后，找出31-40条这四条记录~~~
谢谢各位啦~~ 快，在线等。。

[jiezhi]

select * from
(
select rownum rn,a.* from
(select * from a order by id)
)
where rn between 31 and 40

[mutou123]

不行呀，a.* 总是出错~~

[jiezhi]

select * from
(
select rownum rn,a.* from
(select * from a order by id)a
)
where rn between 31 and 40

[tiangou]

我在8i上测试过，jiezhi(浪子) 的语句没错，不过，为避免引起误会
可改写为：

select * from
(
select rownum rn,b.* from (select * from a order by id) b
)
where rn between 31 and 40

[mutou123]

谢谢~~~各位楼上的两位啦~~