SQL Aggregate function sum()

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

About function sum ()

SQL Sum () function is used to retrieve the total sum of values of a numeric column.

Syntax of function sum()

SELECT sum (column_name) from table_name

Example of function sum()

select 'Sum' =sum(distinct rate) from humanresources.employeepayhistory

function sum() example
SUMMARY

In this chapter, you have learned about SQL Sum () function with an example. In the next chapter you will get some question based on retrieve topics such as select, top, between, where etc. so click on the NEXT button to continue learning.

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.