Italian Trulli

SQL MAX function With Example

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

QA acharya

Post a Comment