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

.

Post a Comment

0 Comments