Invalid use of take in MySQL

[SuperCodeCandy]

• When I was flipping pages using take in MySQL, I found that take was invalid, but I was able to use limit

• limit queryBuilder

    const queryBuild = this.articleClassifyMapRepository
      .createQueryBuilder('articleClassifyMap')
      .leftJoinAndSelect(ArticleClassifyEntity, 'articleClassify', 'articleClassify.id = articleClassifyMap.classifyId')
      .select([
        'count(articleClassifyMap.classifyId) as classifyCount',
        'articleClassify.name as name',
        'articleClassify.tag as tag',
        'articleClassify.id as id'
      ])
      .offset(1)
      .limit(1)
      .groupBy('articleClassifyMap.classifyId')

• limit query

SELECT count(`articleClassifyMap`.`classify_id`) as classifyCount, `articleClassify`.`name` as name, `articleClassify`.`tag` as tag, `articleClassify`.`id` as id FROM `article_classify_map` `articleClassifyMap` LEFT JOIN `article_classify` `articleClassify` ON `articleClassify`.`id` = `articleClassifyMap`.`classify_id` GROUP BY `articleClassifyMap`.`classify_id` LIMIT 1 OFFSET 1

• take queryBuilder

    const queryBuild = this.articleClassifyMapRepository
      .createQueryBuilder('articleClassifyMap')
      .leftJoinAndSelect(ArticleClassifyEntity, 'articleClassify', 'articleClassify.id = articleClassifyMap.classifyId')
      .select([
        'count(articleClassifyMap.classifyId) as classifyCount',
        'articleClassify.name as name',
        'articleClassify.tag as tag',
        'articleClassify.id as id'
      ])
      .skip(1)
      .take(1)
      .groupBy('articleClassifyMap.classifyId')

• take query

SELECT count(`articleClassifyMap`.`classify_id`) as classifyCount, `articleClassify`.`name` as name, `articleClassify`.`tag` as tag, `articleClassify`.`id` as id FROM `article_classify_map` `articleClassifyMap` LEFT JOIN `article_classify` `articleClassify` ON `articleClassify`.`id` = `articleClassifyMap`.`classify_id` GROUP BY `articleClassifyMap`.`classify_id`