select t2.* from(select t1.*,,rownum idx from ( SELECT t.doc_library,t.doc_order,t.doc_name,t.doc_userid,t.doc_flg,t.doc_date,t.doc_scan,t.doc_id,t.doc_download,d.code_dep,d.code_level,d.code_type,d.code_sort FROM KY_DOC t,KY_DOC_CODE d WHERE t.doc_id=d.CODE_ID ) t1 where rownum<{0} order by DOC_ORDER)t2 where t2.idx>{1}