node使用sequelize 分组聚合查询

最新推荐文章于 2024-05-09 09:42:05 发布

Demo_xr

最新推荐文章于 2024-05-09 09:42:05 发布

阅读量733

点赞数

分类专栏： Sequelize nodejs 笔记文章标签： sql servlet 数据库 node.js

本文链接：https://blog.csdn.net/tirst_/article/details/126750717

版权

笔记同时被 3 个专栏收录

30 篇文章 0 订阅

订阅专栏

nodejs

11 篇文章 1 订阅

订阅专栏

Sequelize

5 篇文章 0 订阅

订阅专栏

const result = await model.Operationlog.findAll({
      where: { type: 'kyyuser' },
      group: 'url',
      attributes: ['url', [sequelize.fn('count', sequelize.col('url')), 'total']],
      having: sequelize.literal('total >= 5'),
      order: [[sequelize.literal('total'), 'DESC']],
    });

查询 log日志表中按照url 出现的次数进行排序并且返回出现5次以上url的数据

sql语句下面

SELECT `url`, count(`url`) AS `total` FROM `operationlogs` AS `operationlog` WHERE `operationlog`.`type` = 'kyyuser' GROUP BY `url` HAVING total >= 5 ORDER BY total DESC;