Tell Me Glossary
 

Number Functions

Previous previous|next Next Page

You use number functions to accept numeric input. The number functions return numeric values.

The three most commonly used number functions are the following:

  • ROUND - rounds a column, an expression, or a value to n decimal places.
  • MOD - truncates or chops off a column, an expression, or a value to n decimal places.
  • TRUNC - returns the remainder of x divided by y .