SQL Min Function With Example

.

MIN Function In SQL - How to Use Min Function?

Min Function in SQL with Example

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- the MIN() function column should be numeric.

MIN()Syntax

The Basic syntax For Min Function is 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 the Student table.

Hope!!! The above Tutorial on SQL MIN Function with Example is helpful for you...

Team,

QA acharya