SQL
SELECT MIN MAX Function

MIN() Function

Min function is used to get the minimum value of a column in a table.

Syntax


  SELECT MIN(column_name)
  FROM table_name
  WHERE condition;

Example


  SELECT MIN(fee) AS LargestFee
  FROM Products;

MAX() Function

Max function is used to get the maximum value of a column in a table.

Syntax


  SELECT MAX(column_name)
  FROM table_name
  WHERE condition;

Example


  SELECT MAX(fee) AS LargestFee
  FROM student;