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