Interface FnExpression

Example

// Count all records
User.findAll({
  attributes: [[fn('COUNT', col('id')), 'count']]
})

// Count distinct values
User.findAll({
  attributes: [[fn('COUNT', fn('DISTINCT', col('role'))), 'uniqueRoles']]
})

// Sum with group by
User.findAll({
  attributes: ['role', [fn('SUM', col('score')), 'totalScore']],
  group: ['role']
})
Copy