SQL Min Function With Example

MIN Function In SQL - How to Use Min Function?

Min Function in SQL with Example

Min Function Is Used To display the Smallest Record From the Selected Column
To Showing The Smallest Value From a column We Use The Min Function
NOTE- the MIN() function column should be numeric.

Syntax of Min Function 
The Basic syntax For the 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 the 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...

QA acharya

Post a Comment