ShowAggregateFunctions

Table of Contents

Overview
Prototype
Returns

Example

See also
Related

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.

Lists the aggregate functions.

EXEC ShowAggregateFunctions

The home page

SQL :: Aggregate Functions

Aggregate functions compute one value from a group of rows.

SQL :: Alter Procedure

User-defined stored procedures are not currently available.

Returns the average (arithmetic mean) of the values in each group.

Cancels (rolls back) the transaction of the given process, leaving the process connected.

SQL :: CheckpointHealthCounters

Writes the health counters to disk. This is useful when monitoring performance and you need the metrics in the health JSON file.

SQL :: ClearCacheAllocations

Empties the engine's memory cache. The memory is kept allocated for future cache use; call ReleaseCacheAllocations afterwards to return it to the operating system.

SQL :: ClearHealthCounters

Resets the health counters tracked by the engine. This is helpful when performance tuning.

Returns the number of values in each group. Count(0) and Count(*) count the documents in each group.

SQL :: CountDistinct

Returns the number of distinct values in each group. Values are compared without regard to case unless caseSensitive is true.