Comparison Functions
Function and Description | Examples |
|---|---|
GREATEST From a list of expressions, Oracle determines which has the highest numeric precedence. | The following query results in BELIZE: SELECT GREATEST('BELIZE','BELGIUM','BELARUS') "GREATEST" FROM DUAL |
LEAST From a list of expressions, Oracle determines which has the lowest numeric precedence. | The following query results in BELARUS: SELECT LEAST('BELIZE','BELGIUM','BELARUS') "LEAST" FROM DUAL |