count static method

QSelectField count(
  1. QField alias
)

Creates a COUNT aggregate function with optional alias.

alias A QField that specifies the field to count and optional alias.

Returns a QSelectField representing the COUNT function.

Example:

var count1 = SQL.count(QField('id')); // COUNT(`id`)
var count2 = SQL.count(QField('id', as: 'total')); // COUNT(`id`) AS `total`

Implementation

static QSelectField count(QField alias) {
  String as = alias.as.isNotEmpty ? ' AS ${QField(alias.as).toSQL()}' : '';

  String field = QField(alias.value, distinct: alias.distinct).toSQL();
  return QMath('COUNT($field)$as');
}