AVG
, SUM
, COUNT
, MAX
, and MIN
. These can be used with grouping and conditions on groups with the GROUP BY
and HAVING
clauses.COUNT
COUNT
. Since Db.SQL
doesn't support literals, using COUNT(*)
in Db.SQL
will throw ScErrUnsupportLiteral (SCERR7029)
.