oracle内建函数least()

least()函数,用于求一组值中最小值.例如:
1.select least(1,2) from dual;
结果:1
2.select least('阿','吧') from dual;
结果:阿
3.select least('阿','吧','1',1) from dual;
结果:1
比较智慧的运用:
select max(least(2,4,9)) from dual;即在最小值里面找最大的.

转载：http://space.itpub.net/226801/viewspace-686