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;
Tags:
sql