Re: Using the SUM function

Please don't ask us to do your homework.

Regards,

Sybrand Bakker, Oracle DBA

• <NICKB_at_KUBOTA.CO.UK> schreef in berichtnieuws 390ef15d.0_at_tahiti.alcom.co.uk...
  > Hello guys and gals.
  >
  > I have a problem.I need to turn the following query table into summary
  > format. It contains sales information:
  >
  > YEAR CUST ITEM SALES_QTY
  > 1998 ALBA TRACTOR 1
  > 1998 ALBA TRACTOR 1
  > 1998 ALBA TRACTOR 1
  > 1997 ASH TRAILER 2
  > 1996 ASH TRAILER 1
  >
  > Ideally the finished format should look like this:
  >
  > YEAR CUST ITEM SUM(SALES_QTY)
  > 1998 ALBA TRACTOR 3
  > 1997 ASH TRAILER 2
  > 1996 ASH TRAILER 1
  >
  >
  >
  > Please help,
  >
  > regards,
  >
  > Nick.
  >
  >
  >
  >
  >
  >
  > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
  > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
  > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----