Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating A Crosstab Query
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