haci aliyev haci aliyev - 10 months ago 50
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


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.