oracle 分頁查詢語句：
select * from ( select row_.*, rownum rownum_ from (
sql--你要查詢的語句，支持order by) row_ where rownum <=
MAXROW ) where rownum_ >
MINROW
示例：
insert into M2_USER_POINT (id, iuserid, iconsumepoint, isumepoint, iisdelete)
select seq_m2_user_point.nextval as id ,iuserid, iconsumepoint, isumepoint,iisdelete from ( select row_.*, rownum rownum_ from (
select iuserid, iconsumepoint, isumepoint,'0' as iisdelete
from v_club_point
) row_ where rownum <= 10000) where rownum_ >0;
posted on 2005-08-15 09:16
wilin 閱讀(210)
評論(0) 編輯 收藏 所屬分類:
數據庫相關