Scalar function vs Aggregate function in SQL

Scalar functions Aggregate functions
Application operate on each row or value of a column at a time operate on a collection of a column’s rows or values
Output several outputs (as many outputs as rows in the column) single output

The below post lists all the built-in scalar functions in SQLite.

The following are the built-in aggregate functions in SQLite:

1 Like