Re: QUERY WRITING

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 25 Nov 2004 20:46:54 +0100
Message-ID: <41a63605$0$27308$626a14ce@news.free.fr>

"Segun" <orefuja_at_yahoo.com> a écrit dans le message de news:3eced8bb.0411251125.1fed723c_at_posting.google.com...
> 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

select product, england+usa+france+ireland quantity from my_table;?

-- 
Regards
Michel Cadot

Received on Thu Nov 25 2004 - 13:46:54 CST