haci aliyev haci aliyev - 1 year ago 89
SQL Question

How can I calculate sql tables in delphi ?

Hi I have sql table I want to calculate all the fields to total sum field.
enter image description here

Answer Source

You can do this in the SELECT statement you use to get the data, something like

SELECT *, big1 + small1 as "TotalSum"

Obviously, you can add more numeric fields to the fields to sum.