select /*+ first_row */ *
from rsc_bs
where rowid in (select rid from (select rownum rno, rid
from (select rowid rid from rsc_bs
order by id desc)
where rownum <= curpage*page_record )
where rno >= (curpage-1)*page_record+1);
from rsc_bs
where rowid in (select rid from (select rownum rno, rid
from (select rowid rid from rsc_bs
order by id desc)
where rownum <= curpage*page_record )
where rno >= (curpage-1)*page_record+1);
没看懂,/*+ first_row */ * 是什么意思
可否说详细些,谢谢
------------------------------------
rowid oracle 特有的用于唯一标识一行, rid 在该语句中是rowid的别名
,/*+ first_row */
-------------------------
应该是你需要取的字段吧