SQL Aggregate function min()

OBJECTIVE

In this chapter you will learn:

About function Min ()
Syntax function of Min ()
Example of function Min ()

 

About function Min ()

SQL min () function is used to retrieve the minimum value in the expression. If you have the records with different values and want to display or retrieve the lowest or minimum value then you can use this aggregate function.

 

Syntax function of Min ()

SELECT min (column_name) from table_name

Example of function Min ()

 

 

function min()

 

SUMMARY

In this chapter you have learned about SQL Min () function with an example. In the next chapter you will learn about SQL function Max ().


Leave a Reply

Your email address will not be published. Required fields are marked *