GREATEST()函式返回輸入引數(n1, n2, n3, 等)組的最大值。下面的範例使用 GREATEST()函式從一組數位值中返回最大的值:
mysql>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)