least和greatest

Least:返回一组数的最小数，有null则返回null
SQL> Select Least(1,-1,2) From dual ;
LEAST(1,-1,2)
-------------
           -1


SQL> Select Least('b','dc') From dual ;
LEAST('B','DC')
---------------
b


SQL> Select Least('b','啊') From dual ;
LEAST('B','啊')
---------------
b


SQL> Select Least('b',1,'2') From dual ;
LEAST('B',1,'2')
----------------
1


SQL> Select Least('啊','吧') From dual ;
LEAST('啊','吧')
----------------
啊


SQL> Select Least('啊','a',1,Null) From dual ;
LEAST('啊','A',1,NULL)
----------------------

null

Greatest:返回一组数的最大数,有null则返回null

SQL> select greatest(1,2,3) from dual ;
GREATEST(1,2,3)
---------------
              3


SQL> select greatest('a','3','5') from dual ;
GREATEST('A','3','5')
---------------------
a


SQL> select greatest('a','3','啊','5') from dual 
  2  /
GREATEST('A','3','啊','5')
--------------------------
啊


SQL> select greatest('a','3','啊','5', null) from dual ;
GREATEST('A','3','啊','5',NULL
------------------------------


SQL>