can I use sum with computed by

Article View: borland.public.interbase.sql

Article #71

Back to borland.public.interbase.sql Previous Next

#71

From: Isaac
Date: Tue, 27 May 2008 19:59

8 lines
1069 bytes

Hello,
I wonder if I can use computed by to sum all detail records or is it 
only limited to the current table ?.

ex
select sum(f) from table where f2 = value

Thanks

Technical Details

Message-ID: <483c6824@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!eweka.nl!lightspeed.eweka.nl!213.132.189.2.MISMATCH!multikabel.net!feed20.multikabel.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,f81bba07595296f5,start
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 27 May 2008 22:59:21 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: can I use sum with computed by
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.198.147
Message-ID: <483c6824@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211918372 41.234.198.147 (27 May 2008 12:59:32 -0700)
Lines: 8
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!eweka.nl!lightspeed.eweka.nl!213.132.189.2.MISMATCH!multikabel.net!feed20.multikabel.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail