Previous
Topic:
Value Expression Primaries |
Next
Topic: Aggregate Functions |
A function is a named, specialized operation performed on zero or more input values, that returns a single value when executed successfully. A function can appear anywhere a value expression is permitted. The function is invoked by its name, followed by the input argument(s) (if any) in parentheses.There are several categories of functions: Aggregate, OLAP, Cast, String, Math, and Date/Time.
- Aggregate
- AVG
- COUNT
- MAX
- MEANDEV
- MEDIAN
- MIN
- STDDEV
- SUM
- SUMSQ
- VARIANCE
- OLAP
- CUME_DIST
- DENSE_RANK
- NTILE
- PERCENT_RANK
- RANK
- ROW_NUMBER
- Cast
- String
- Math
- Date/Time
Previous
Topic:
Value Expression Primaries |
Next
Topic: Aggregate Functions |