Progress
SQL-92
Guide and Reference
SQL-92 Functions
A function is a type of SQL expression that returns a value based on the arguments supplied to the function. Progress SQL-92 supports two types of functions:
- Aggregate Functions — Calculate a single value for a collection of rows in a result table. If the function is in a statement with a GROUP BY clause, it returns a value for each group in the result table. Aggregate functions are also called set or statistical functions. Aggregate functions cannot be nested. This chapter describes the Aggregate Functions listed in Table 4–1.
- Scalar Functions — Calculate a value based on another single value. Scalar functions are also called value functions. Scalar functions can be nested. This chapter describes the Scalar Functions listed in Table 4–2.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |