Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Is it possbile to SUM the members of a group expression in SQL?
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) Received on Sun Nov 11 2001 - 01:37:35 CST