OFFSET 只不过是一个指示表中起始游标的关键字

SELECT column FROM table LIMIT 18 OFFSET 8 -- fetch 18 records, begin with record 9 (OFFSET 8)

你会得到同样的结果表

SELECT column FROM table LIMIT 8, 18

视觉表现( R 是表中按某种顺序排列的一条记录)

 OFFSET        LIMIT          rest of the table
 __||__   _______||_______   __||__
/      \ /                \ /
RRRRRRRR RRRRRRRRRRRRRRRRRR RRRR...
         \________________/
                 ||
             your result