猪猪SOFT

oracle分页查询

SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM hb_usr_subcriptions order by uss_id asc) A WHERE ROWNUM <= 10 ) WHERE RN >= 1