LIMIT ... OFFSET ... 截取

LIMIT … OFFSET … 截取
LIMIT 截取的数量
OFFSET 从第几个开始截取

SELECT column1, column2, ... 
FROM table WHERE condition(s) 
ORDER BY colunmn ASC/DESC 
LIMIT num_limit OFFSET num_offset