SELECT * FROM ( SELECT ROW_NUMBER() OVER() AS rownum, mytable.* FROM mytable) AS tmp WHERE rownum <= 9 and rownum>6;
从第六条数据到第九条
SELECT * FROM ( SELECT ROW_NUMBER() OVER() AS rownum, mytable.* FROM mytable) AS tmp WHERE rownum <= 9 and rownum>6;
从第六条数据到第九条