SQL Functions: GREATEST

GREATEST:

This function used to get the greatest value from a list of one or more expressions

Select GREATEST (‘XXXY’,’XXXX’) FROM DUAL;

Output: XXXY