Question

The MAX () function finds the

Options

• Maximum number of records entered in a table

• Maximum number of rows allowed to be entered

• Maximum value of the selected column

• None of these

Answer 1

Maximum value of the selected column

Explanation - 

The SQL MAX() method is used to return an expression's highest possible value in a SELECT statement. For instance, FROM student, SELECT MAX (per) AS "Highest Percentage". The aforementioned line will yield the highest percentage number from the PER column in the STUDENT table.