$count

[Anon]

I have a database with a number of rows with amounts in.

What is the correct sql query to add all these amounts up so i can displey it.

Hope this is simple for someone.

Thanks if you can help

Lee

[[deleted]]

SELECT SUM("COL_NAME") FROM "TABLE NAME"