空山新雨 · 2006-08-01 02:53:33 · 阅读: 504 嘿嘿,想分页吧?Oracle: SELECT * FROM ( SELECT [column list], ROWNUM AS row_num FROM [table list] WHERE ROWNUM <= 100 ) WHERE row_num > 5;