Knowledge Hub — Technical Document

Generated on 2026-08-28 07:02 | Confidential Client Asset

GREATEST and LEAST

Published July 26, 2025 By Sai Sree Ram Gundepudi

GREATEST and LEAST Functions

GREATEST

Returns the highest value among provided expressions.

SELECT GREATEST(100, 200, 300, 50) FROM dual; -- Output: 300

LEAST

Returns the lowest value.

SELECT LEAST(100, 200, 300, 50) FROM dual; -- Output: 50

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article