In MAX () function used to get the largest value of the selected column.
SELECT MAX(column_name)
FROM table_name
WHERE condition;
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 |
SELECT MAX(Run) AS HighestRun
FROM cricket_score;