Hello, i need help on this, appreciate very much:

ID Price Amount
-- ---- -------
1 15 4
2 20 2

How to display out the total of it? Example above, the total should be 100, but how to apply it in programming environment.

Thanks very much for the contribute help.

in SQL

SELECT SUM(price * amount) as total_value

Make sure you add "from {table}". Just in case...Hirst didn't because you didn't supply the table name. But just because I see that question being asked, it's:

Select Sum (price * amount) from {table} <--- replace this part with the name of your table.

Good catch

Someone's gotta make sure you're corrected on the 2 times a year you mess up. The 4998 times you're right have nothing to do with it.

Thanks man