Re: Creating A Crosstab Query

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: 1997/11/21
Message-ID: <3475b3a5.22023057@read.news.global.net.uk>#1/1

On Fri, 21 Nov 1997 07:21:30 -0600, Abeeda_Mohammed_at_xn.xerox.com wrote:

>RDBMS Version: 7.3.2.3.1
>Operating System: NT 4.0
>Product: PL/SQL 2.3.2.3
>Product Version: 2.3.2.3
>
>
>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
>what the description is going to be so I cannot write a SQL stmt. with
>sum(decode.. function to perform this crosstab query.
>
>Is there a way out?
>
>thanks in advance,
>
>Abeeda
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
You can either use a reporting tool with built in support for crosstabs, or you can dynamically build an sql statement by first getting distinct values of description and then using decode. Received on Fri Nov 21 1997 - 00:00:00 CST