Aggregate function max()

In this chapter you will learn:
About function Max ()
Syntax of function Max ()
Example of function Max ()

About function Max ()

SQL max () function used to returns the largest or highest value in the expression. If you have the records in a database and you want to retrieve or display the maximum value then you can use this function.

Syntax of function Max ()

SELECT max (column_name) from table_name

Example of function Max ()

select 'Maximum Rate' = max(Rate)from humanresources.employeepayhistory
function-max
SUMMARY

In this chapter, you have learned about function max () which is an aggregate function and used to retrieve largest or maximum value. In the next chapter you will learn about function sum().

 

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.