SQL Oracle PHP Java JSP JDBC MORE

SQL MAX Function with Example


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

SQL MAX() Syntax

SELECT MAX(column_name)
FROM table_name
WHERE condition;

SQL 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

SQL Query

SELECT MAX(Run) AS HighestRun
FROM cricket_score;

Output

HighestRun

82