Reference Guide > TDV Support for SQL Functions > Numeric Functions > TOTALORDER
 
TOTALORDER
The TOTALORDER function returns an ordering for DECFLOAT values. The TOTALORDER function returns a small integer value that indicates how expression1 compares with expression2.
Syntax
TOTALORDER(decfloat, decfloat)
Example
select TOTALORDER(DECFLOAT(-1.1), DECFLOAT(-1.2))