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...

QA acharya

Post a Comment