Italian Trulli

SQL Min Function With Example

Test Tribe
MIN Function In SQL - How to Use Min Function?

Min Function in SQL with Example
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.

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

QA acharya

Post a Comment