SQL Oracle Java JSP JDBC PHP MORE

Oracle MAX Function with Example

In MAX () function used to get the largest value of the selected column.

Oracle MAX() Syntax

SELECT MAX(column_name)
FROM table_name
WHERE condition;

Oracle MAX() Example

In this example we show you highest run of Virat.

Table Name :cricket_score

MatchNo Name Run Wicket
1 Virat 78 1
2 Virat 82 2
3 Viart 50 0

Oracle Query

SELECT MAX(Run) AS HighestRun
FROM cricket_score;

Output

HighestRun

82