Mega Code Archive

 
Categories / MySQL Tutorial / Comparison Functions Operators
 

GREATEST(value1,value2, ) returns NULL if any argument is NULL

mysql> mysql> SELECT GREATEST(2,NULL); +------------------+ | GREATEST(2,NULL) | +------------------+ |             NULL | +------------------+ 1 row in set (0.00 sec) mysql>