阿紫的姐夫,赫赫。降龙十八掌都会了,这个不会?可以用rownum等等。select * from (select rownum id ,* from t1 where rownum <=30) where id between 16 and 30??
00:30:17,勤奋呀! 习武之人就是不一样!SELECT * FROM 表名 WHERE id IN( SELECT id FROM (SELECT ROWNUM AS numrow, ID FROM 表名 ORDER BY id) WHERE numrow > 每页显示记录数 * (当前页-1) AND numrow <= 每页显示记录数 * 当前页 )ORDER BY id
(select rownum id ,* from t1 where rownum <=30)
where id between 16 and 30??
习武之人就是不一样!SELECT * FROM 表名 WHERE id IN(
SELECT id FROM
(SELECT ROWNUM AS numrow, ID FROM 表名 ORDER BY id)
WHERE numrow > 每页显示记录数 * (当前页-1)
AND numrow <= 每页显示记录数 * 当前页
)ORDER BY id