[TOC] ### limt 分頁查詢 ### 查詢前3條記錄 分頁公式：  `(offset - 1) * limit` ~~~ SELECT name FROM `student` LIMIT 0, 3; Student.findAll( { attributes:['name'], // 當前頁 offset:0, // 每頁顯示的條數 limit:3 }) ~~~ ***** ### 分頁案例 ~~~ router.get('/getUserList', async (ctx, next) => { let { currentPage=1, count=10 } = ctx.request.header; const userList = await models.user.findAllAndCount({ limit: parseInt( count ), offset:(currentPage - 1) * count, include: [{ model: { explore }, as: 'order_info' }], distinct: true }).then(res => { let result = {}; result.data = res.rows; result.totalCount = res.count; return result; }); ctx.body = userList; }); ~~~