Re: How do I..... (PL/SQL ?) newbie question.
From: David <ds_at_netvigator.com>
Date: 1996/08/16
Message-ID: <01bb8b8b$b7409a80$LocalHost_at_ds>#1/1
Steven Kell <skell_at_binc.net> wrote in article <4ullhr$l4v_at_grandcanyon.binc.net>...
Date: 1996/08/16
Message-ID: <01bb8b8b$b7409a80$LocalHost_at_ds>#1/1
try this
select cust#, sum(gross_revenue) from basetable group by cust#
Steven Kell <skell_at_binc.net> wrote in article <4ullhr$l4v_at_grandcanyon.binc.net>...
> I have a base table for sales data that has fields for cust#,
cust_location#,
> (some customers have multiple locations, but the same cust# for all
> locations) quarter, year, and gross_revenue....
> How can I find the total gross revenue for each cust#, regardless of what
> the cust_location#, qtr or year are? I want a sum total of gross_rev for
> cust# 1, cust# 2 for all quarters in all years.
Received on Fri Aug 16 1996 - 00:00:00 CEST