Menu

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








Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)

Subscribe