Oracle

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)）;