67,512
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM (
SELECT t.*, rownum AS rn FROM (
SELECT * FROM t_news m ORDER BY m.id
) t
) x
WHERE x.rn >= 6 AND x.rn <= 10;
SELECT * FROM (
SELECT t.*, row_number() OVER(ORDER BY id) AS rn FROM t_news t
) x
WHERE x.rn >= 6 AND x.rn <= 10;