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 the Largest Record From the Selected Column

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

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

Syntax of Max Function

The Basic syntax For the 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 the 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