SmallSQL Database SQL Functions

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:
  • SQL Date and Time Functions
  • SQL Numeric Functions
  • SQL String Functions
  • SQL System Functions
  This functions are also available via escape function.
  
  
   
• SQL Aggregate Functions
  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 support with a feature request.

see also:
SQL Syntax