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

Post a Comment