1、GREATEST(ch) ch为英文逗号隔开的字符串,返回字符串中最大的一个
select GREATEST(1,2,3,4) a1 from dual;
select GREATEST('ABC','ABA','ABB','AAA') a1 from dual;
select GREATEST(sysdate,sysdate+1,sysdate-1) a1 from dual;
2、LEAST(ch) ch为英文逗号隔开的字符串,返回字符串中最小的一个
select LEAST(1,2,3,4) a1 from dual;
select LEAST('ABC','ABA','ABB','AAA') a1 from dual;
select LEAST(sysdate,sysdate+1,sysdate-1) a1 from dual;