詞語:rownum
rownum的參考例句
1.delete from tab_name where rownum > 100; 不知道怎麼刪除100條以後的數據;
2.select id, first_name, salary from (select rownum row_num, id, first_name, salary from (select * from s_emp order by salary)) where row_num between 11 and 20; 根據工資由低到高,查詢工資在11到20位排名的員工。(分頁功能)