SQL MAX function

.

MAX Function In SQL

MAX () 

MAX Function Is Used To display Largest Record From Selected Column

To Showing The Largest Value From a column We Use The MAX Function

NOTE- for the MAX() function column should be numeric.

MAX ()Syntax- The Basic syntax For MAX Function Given Below

SELECT MAX (column_name)FROM table_name WHERE condition;

MAX Function Example-

SQL Query-

SELECT MAX (Marks)FROM Student;

In Above Example It Will Display The Largest Number from the Marks column in Student table

.