SELECT SUM(<column>) FROM <table> [WHERE <conditions>]

SUM() returns the total value in a column. SUM() can only be used on numerical column.

Table: Orders

OrderID	Customer	Employee	Order Date	ShippedVia	Freight	ShipCountry
10248	Wilman Kala	Buchanan, Steven	04-07-1996	Federal Shipping	$32.38	France
10249	Hanari Carnes	Peacock, Margaret	08-07-1996	United Package	$65.83	Brazil
10250	Hanari Carnes	Leverling, Janet	08-Jul-1996	United Package	$58.17	Brazil
10251	Chop-suey Chinese	Buchanan, Steven	11-Jul-1996	United Package	$22.98	Switzerland
10252	Richter Supermarkt	Dodsworth, Anne	12-Jul-1996	Federal Express	$148.33	Switzerland

The following example return 327.69. (327.69 = 32.38 + 65.83 + 58.17 + 22.98 + 148.33)

SELECT SUM(Freight) FROM Orders

Resultset1

327.69

.