SQL Min Function

MIN Function In SQL

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.


Post a Comment