Ingres 12.0 | SQL Functions

SQL Reference Guide > SQL Reference Guide > Understanding the Elements of SQL Statements > SQL Functions

Was this helpful?

SQL Functions

Functions can be used in the following SQL statements:

• SELECT

• INSERT

• UPDATE

• DELETE

• WHILE

• IF

Scalar functions take single-valued expressions as their argument.

Aggregate functions take a set of values (for example, the contents of a column in a table) as their argument. Aggregate functions cannot be used in WHILE or IF statements.

Last modified date: 08/29/2024