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

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.