SQL MAX function With Example

.

MAX Function In SQL - How to use Max Function in SQL?

Max Function in SQL with example

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- the MAX() function column should be numeric.

MAX ()Syntax

The Basic syntax For MAX Function is 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 the Student table.

Hope !!! The above Tutorial on the Max function with Example is helpful for you...

Team,

QA acharya