In SQL there exists 3 Types of functions
- SQL Scalar functions
Scalar functions has a list of parameters and return a single value. Scalar
functions can be used on any place where a expression is valid. There are
the follow categories:
This functions are also available via escape function.
- SQL Aggregate
Accumulate a list of values and return a single values.
- Rowset functions
Can use like tables or views. SmallSQL does not support it currently. If you
have a requirement for it then contact the
with a feature request.