Scalar Functions

Scalar functions represent scalar values. The syntax is

scalar-exp ::= <term> | <scalar-exp> <addop> <term>
addop      ::= + | -
term       ::= <factor> | <term> <multop> <term>
multop     ::= * | /
factor     ::= <literal> | <column-ref> | <function-ref> |
               (<scalar-exp>)

Example: Specifying a Scalar Expression

COUNT(DISTINCT EMP_NBR)
3 * (AMOUNT + BALANCE)