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: QUERY WRITING

Re: QUERY WRITING

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 28 Nov 2004 22:22:12 -0800
Message-ID: <1101709240.231574@yasure>


Segun wrote:

> Hi all,
> I have a table with data as shown below
>
> PRODUCT ENGLAND USA FRANCE IRELAND
> Orange 100 101 100 90
> Mango 110 110 110 80
> Pawpaw 100 120 112 100
> Grape 105 130 124 115
> Banana 115 140 100 150
>
> Can someone please help generate a code to produce an output as shown below
>
> PRODUCT QUANTITY
> Orange 391
> Mango 410
> Pawpaw 432
> Grape 474
> Banana 505
>
> Thanks all, while expecting the reply urgently.
>
> Olu

Your problem is that your data is nor normalized. Normalize the data by restructuring the table and then write your own query.

In short ... we don't do other people's homework for them.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Nov 29 2004 - 00:22:12 CST

Original text of this message

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