In order to get the maximum charge from a column, SQL offers a function which is known as MAX. The main structure of this function is given below:-
If we have to find out the uppermost sale of a column then the structure will be like that;
Los Angeles $1200 Jan-05-2011
San Diego $350 Jan-07-2011
Boston $450 Jan-08-2011
Boston $750 Jan-08-2011
The syntax is given below;
$2750 shows the highest value of the sales column which has the following values: $1200, $350, $450, and $750.