Oracle分页查询
pc :每页的总记录数
ps:第几页
SELECT * FROM (SELECT ROWNUM AS rowno, t.* FROM demo
where ROWNUM <= (pc*ps)) table_alias
WHERE table_alias.rowno >= (pc*(ps-1));
Oracle分页查询
pc :每页的总记录数
ps:第几页
SELECT * FROM (SELECT ROWNUM AS rowno, t.* FROM demo
where ROWNUM <= (pc*ps)) table_alias
WHERE table_alias.rowno >= (pc*(ps-1));