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>)
COUNT(DISTINCT EMP_NBR)
3 * (AMOUNT + BALANCE)
iWay Software |