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.

Post a Comment

0 Comments