Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!novia!novia!intgwlon.nntp.telstra.net!newsfeeds.bigpond.com!not-for-mail
User-Agent: Microsoft-Entourage/9.0.1.3108
Subject: Is it possbile to SUM the members of a group expression in SQL?
From: Chris Newman <chris_newman@bigpond.com>
Newsgroups: comp.databases.oracle.misc
Message-ID: <B81475EF.A2FB%chris_newman@bigpond.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
Lines: 19
Date: Sun, 11 Nov 2001 18:37:35 +1100
NNTP-Posting-Host: 203.54.110.125
X-Trace: newsfeeds.bigpond.com 1005464145 203.54.110.125 (Sun, 11 Nov 2001 18:35:45 EST)
NNTP-Posting-Date: Sun, 11 Nov 2001 18:35:45 EST
Organization: Telstra BigPond Internet Services (http://www.bigpond.com)
Xref: easynews comp.databases.oracle.misc:72010
X-Received-Date: Sun, 11 Nov 2001 04:15:14 MST (news.easynews.com)

SUM only works on the entire column.

But is it possible to produce a subtotal so that table with contents this

Name date1  price
Name date1  price
Name date1  price
Name date1  price
Name date2  price
Name date2  price
Name date2  price
Name date2  price


Displays as

Name Date1 (total prices related to date1)
Name Date2 (total prices related to date2)