GREATEST and LEAST Functions
GREATEST
Returns the highest value among provided expressions.
SELECT GREATEST(100, 200, 300, 50) FROM dual; -- Output: 300LEAST
Returns the lowest value.
SELECT LEAST(100, 200, 300, 50) FROM dual; -- Output: 50Returns the highest value among provided expressions.
SELECT GREATEST(100, 200, 300, 50) FROM dual; -- Output: 300Returns the lowest value.
SELECT LEAST(100, 200, 300, 50) FROM dual; -- Output: 50