Re: Sum of rows

Article View: borland.public.interbase.sql

Article #907

Back to borland.public.interbase.sql Previous Next

#907

From: aleplgr
Date: Mon, 16 Apr 2007 10:40

11 lines
1241 bytes

>If I understand your description correctly then this should be workable in a 
>single SQL statement.
>
>select PatientID, Date, Tester, Sum(Points) as SumPoints
>from table
>where Items in ('itemA', 'itemB', 'itemC')
>group by PatientID, Date, Tester
>
>-- 
Thanks!!! Yes, you understood the description correctly and that was exactlly what I need

Technical Details

Message-ID: <46234480$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news.motzarella.org!news.albasani.net!feeder06.uucp-net.de!reader.uucp.at!newsfeed.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail

References: <4621e830$1@newsgroups.borland.com> <46224fa6@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,f48a4e6400e7b013
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "aleplgr" <aleplgr@yahoo.es>
Sender: "aleplgr" <aleplgr@yahoo.es>
Reply-To: "aleplgr" <aleplgr@yahoo.es>
Subject: Re: Sum of rows 
Newsgroups: borland.public.interbase.sql
X-User-Info: 80.58.205.38     
X-Forwarded-For: 80.25.195.180, 192.168.1.66
References: <4621e830$1@newsgroups.borland.com> <46224fa6@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <46234480$1@newsgroups.borland.com>
Date: 16 Apr 2007 02:40:16 -0800
X-Trace: newsgroups.borland.com 1176716416 207.105.83.66 (16 Apr 2007 02:40:16 -0800)
Lines: 11
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news.motzarella.org!news.albasani.net!feeder06.uucp-net.de!reader.uucp.at!newsfeed.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail

Reply to Parent Message