OracleNumeric FunctionsLEAST
GREATEST

LEASTNumeric Functions

NANVL

Returns the smallest value from a list.

Syntax

LEAST(v, ...)

Example

Enter values below to update the example in real time.

price_a
price_b
price_c
min_price
price_comparison
SELECT LEAST(price_a, price_b, price_c) AS min_price
FROM price_comparison;