Use the MAX() aggregate function to determine a column’s maximum value; this function accepts the name of the column you wish to determine the maximum value for as a parameter. The maximum will be determined for each record in the table if you don’t include any more columns in the SELECT clause.