ShowAggregateFunctions

Table of Contents



Lists the built-in aggregate functions with their parameters and descriptions.

ShowAggregateFunctions()

Name, ReturnType, Parameters and Description. Each prototype is also returned as a message.

round-pushpin Lists the aggregate functions.
EXEC ShowAggregateFunctions




SQL :: ShowVersion
Shows the names and versions of the engine's assemblies, or of every loaded assembly when showAll is true.
SQL :: ShowWaitingLocks
Shows the processes that are currently blocked waiting for a lock, optionally for a single process.
SQL :: Sleep
Pauses the executing query for the given number of milliseconds. Useful for testing locking and timeouts.
SQL :: Sum
Returns the total of the values in each group.
SQL :: Syntax
Basic KBSQL syntax and some examples.
SQL :: System Procedures
Built-in procedures for inspecting and managing the database engine.
SQL :: Terminate
Terminates a process: rolls back its transaction, disconnects it and frees its resources. Kill does the same thing.
SQL :: Variance
Returns the population variance of the values in each group: how far the values are spread from their mean.