摘要： select h.id from (select t.id, rownum as rn from ysp_application t where t.yxbz = 'Y' order by t.sqsj asc) h where h.rn between 1 and 100 order by h.rn asc; 阅读全文