haci aliyev haci aliyev - 6 months ago 16
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

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.