GREATEST()函數(shù)返回在該組輸入?yún)?shù)(N1,N2,N3,等等)的最大值。 下面的示例使用GREATEST()函數(shù)從一組數(shù)字值返回最大值:
SQL>SELECT GREATEST(3,5,1,8,33,99,34,55,67,43); +---------------------------------------------------------+ | GREATEST(3,5,1,8,33,99,34,55,67,43) | +---------------------------------------------------------+ | 99 | +---------------------------------------------------------+ 1 row in set (0.00 sec)