Numeric data includes fixed-point numbers, floating-point numbers, and zeros.
The following list provides the comparison rules for numeric data:
- Larger values are larger than smaller values. For example, 5.5 is larger than 2.1.
- Negative values are smaller than zeros. For example, -3 is smaller than 0 and -200 is smaller than -1.
- Positive values are larger than zeros. For example, 20 is larger than 0 and 100 is larger than 1.
