oracle分页查询sql
select * from ( select row_.*, rownum rownum_ from ( select * from table1 this_ order by this_.createTime desc ) row_ where rownum <= 3 ) where rownum_ > 1
注册时间:2009-05-22