OraFAQ Forum: SQL & PL/SQL » SUM A COLUM GROUPED BY ANOTHER

Home » SQL & PL/SQL » SQL & PL/SQL » SUM A COLUM GROUPED BY ANOTHER

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SUM A COLUM GROUPED BY ANOTHER [message #692]

Wed, 27 February 2002 01:51

Antoni
Messages: 8
Registered: February 2002

Junior Member

HI

I HAVE A TABLE LIKE THIS ONE:

TABLE PURCHASING

COLUMN 1 CLIENT CODE PK
COLUMN 2 PRODUCT CODE PK
COLUMN 3 PURCHASE PK

SO THAT I CAN HAVE A CLIENT THAT HAS BOUGHT THE SAME PRODUCT SEVERAL TIMES. I WANT TO KNOW THE TOTAL PURCHASE FOR EACH PRODUCT, GROUPED BY CLIENT AND PRODUCT

I AM DOING THIS, BUT IT IS NOT WORKING

SELECT DISTINCT CLIENT CODE, PRODUCT CODE, PURCHASE FROM TABLE PURCHASING GROUP BY CLIENT CODE, PRODUCT CODE, PURCHASE CODE;

THANK YOU

Report message to a moderator