如何在delphi中计算sql表? [英] How can I calculate sql tables in delphi ?

问题描述

我有sql表，我想计算所有字段为总和字段.

Hi I have sql table I want to calculate all the fields to total sum field.

推荐答案

您可以在用于获取数据的SELECT语句中执行此操作，例如

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

SELECT *, big1 + small1 as "TotalSum" from adlar

很明显，您可以在字段中添加更多数字字段以求和.

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

这篇关于如何在delphi中计算sql表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！