SQL Min Function

MIN Function In SQL

 MIN()

Min Function Is Used To display Smallest Record From Selected Column

To Showing The Smallest Value From a column We Use The Min Function

NOTE- for the MIN() function column should be numeric.

MIN()Syntax- The Basic syntax For Min Function Given Below

SELECT MIN(column_name)FROM table_name WHERE condition;

MIN Function Example

SQL Query-

SELECT MIN(Marks) FROM Student;

In Above Example It Will Display The Smallest Number from the Marks column in Student table.