Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating A Crosstab Query

Re: Creating A Crosstab Query

From: Marc Billiet <Marc.Billiet_at_alcatel.be>
Date: 1997/11/21
Message-ID: <34759806.6C04@alcatel.be>#1/1

Abeeda_Mohammed_at_xn.xerox.com wrote:  

> The following is the structure of a table :
> inventory_item_id
> Organization_id
> cost_type_id
> summary_resource_id
> description
> item_cost
>
> I want to write a query so that I can get the sum of item_cost for each
> description, i.e the description should appear as a column. I am not sure

Is it this that you want ?

select description, sum(item_cost)
from your_table
group by description

Marc Received on Fri Nov 21 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US