Re: Using SUM function

Hi

Select YEAR, CUST, ITEM, SUM(SALES_QTY)

        FROM SALES
        GROUP BY  YEAR, CUST, ITEM
        ORDER BY YEAR DESC;

 rgrds Kari

 (Mr.) Kari Pannila

       Oracle DBA

-- 

PS. Delete X from my mail address , it (X) is only for SPAMMERS.
    Poista X mail-osoitteen edestä, se on SPAMmereita varten.

******** wrote:


> 

> 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! =-----