Scalar function vs Aggregate function in SQL

[Sahil]

	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.

List of built-in functions available in SQLite

The following is a list of built-in core functions available in SQLite. This excludes Date & Time functions, aggregate functions, window functions, and JSON functions; which are documented separately. abs(X) changes() char(X1,X2,…,XN) coalesce(X,Y,…) glob(X,Y) hex(X) ifnull(X,Y) iif(X,Y,Z) instr(X,Y) last_insert_rowid() length(X) like(X,Y) like(X,Y,Z) likelihood(X,Y) likely(X) load_extension(X) load_extension(X,Y) lower(X) ltrim(X) ltrim(X,Y) max(X,Y,…) min(X,Y,…) nullif(X,Y) printf(FORMAT,…) q…

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

• avg(X)
• count(*)
• count(X)
• group_concat(X)
• group_concat(X,Y)
• max(X)
• min(X)
• sum(X)
• total(X)