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.

 

Share your thought