javascript - 可以 Sequelize sum、count、group by 还是我应该使用 sequelize.query 选项？

Question

可以 Sequelize sum、count、group by 还是我应该使用 sequelize.query 选项？

select count(col1), sum(col2) from my_table
group by col1

Answer 1

当然可以。

Model.findAll({
  attributes: [
       [db.sequelize.fn('count', db.sequelize.col('col1'), 'col1')],
       [db.sequelize.fn('sum', db.sequelize.col('col2'), 'col2')]
  ],
  group: ['col1']
});