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

标签： javascriptnode.jssequelize.js

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']
});