Function List (Language Reference Guide)

From InterBase
Jump to: navigation, search

Go Up to SQL Statement and Function Reference


The following table lists the SQL functions described in this chapter:

Function Type Purpose

AVG()

Aggregate

Calculates the average of a set of values.

CAST()

Conversion

Converts a column from one data type to another.

COUNT()

Aggregate

Returns the number of rows that satisfy a query’s search condition.

EXTRACT()

Conversion

Extracts date and time information from DATE, TIME, and TIMESTAMP values.

GEN_ID()

Numeric

Returns a system-generated value.

MAX()

Aggregate

Retrieves the maximum value from a set of values.

MIN()

Aggregate

Retrieves the minimum value from a set of values

SUM()

Aggregate

Totals the values in a set of numeric values.

UPPER()

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.