Topic: SUM of a field
Hi
How can I do a SUM of a numerical field with and without a filter .
Example a field cald PROFITS I want to make sum of all fileds in all raws that contain a value bigger then 100 ?
how can it be done ?
Elico
My Visual Database → SQL queries → SUM of a field
Hi
How can I do a SUM of a numerical field with and without a filter .
Example a field cald PROFITS I want to make sum of all fileds in all raws that contain a value bigger then 100 ?
how can it be done ?
Elico
You can use calculated field for that purpose:
(SELECT TOTAL(profits) FROM tablename WHERE profits > 100)
Thanks
Elico
My Visual Database → SQL queries → SUM of a field
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi