OracleNumeric FunctionsGREATEST
BITAND

GREATESTNumeric Functions

LEAST

Returns the largest value from a list.

Syntax

GREATEST(v, ...)

Example

Enter values below to update the example in real time.

score_math
score_eng
score_sci
best_score
exam_results
SELECT GREATEST(score_math, score_eng, score_sci) AS best_score
FROM exam_results;