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.
0 Comments