oracle分页样例
SELECT *
FROM (SELECT ROWNUM AS rowno, t.*
FROM TB_CERT t
WHERE ROWNUM <= 20) table_alias
WHERE table_alias.rowno >= 10;
oracle分页样例
SELECT *
FROM (SELECT ROWNUM AS rowno, t.*
FROM TB_CERT t
WHERE ROWNUM <= 20) table_alias
WHERE table_alias.rowno >= 10;
评论区