Function List (Language Reference Guide)
Go Up to SQL Statement and Function Reference
The following table lists the SQL functions described in this chapter:
Function | Type | Purpose |
---|---|---|
|
Aggregate |
Calculates the average of a set of values. |
|
Conversion |
Converts a column from one data type to another. |
|
Aggregate |
Returns the number of rows that satisfy a query’s search condition. |
|
Conversion |
Extracts date and time information from |
|
Numeric |
Returns a system-generated value. |
|
Aggregate |
Retrieves the maximum value from a set of values. |
|
Aggregate |
Retrieves the minimum value from a set of values |
|
Aggregate |
Totals the values in a set of numeric values. |
|
Conversion |
Converts a string to all uppercase. |
Aggregate functions perform calculations over a series of values, such as the columns retrieved with a SELECT
statement.
Conversion functions transform data types, either converting them from one type to another, or by changing the scale or precision of numeric values, or by converting CHARACTER
data types to all uppercase.
The numeric function, GEN_ID()
, produces a system-generated number that can be inserted into a column requiring a numeric data type.