INFINITY
All functions > CONSTANT > INFINITY
Returns the floating-point representation of positive infinity.
Syntax
INFINITY()sql
Arguments
| Parameter | Type | Required | Description |
|---|
Returns
DOUBLE - Positive infinity
Notes
- Represents positive infinity in floating-point arithmetic
- Used in mathematical calculations involving limits
- Greater than any finite number
- Infinity + any finite number = Infinity
- Infinity / finite number = Infinity