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;