SQL Aggregate function min()

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 ()

select 'Minimum Rate' = min(Rate)from humanresources.employeepayhistory

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

 

Share your thought