Re: SQL Query
From: Ban Spam <ban-spam_at_operamail.com>
Date: Wed, 16 Oct 2002 22:34:18 GMT
Message-ID: <Xns92A99E687C6BESunnySD_at_68.6.19.6>
Date: Wed, 16 Oct 2002 22:34:18 GMT
Message-ID: <Xns92A99E687C6BESunnySD_at_68.6.19.6>
gavspp_at_yahoo.com (gavs) wrote in
news:54dc4b2a.0210160800.64c6c327_at_posting.google.com:
> Hello:
>
> I need help with formulating a sql query without using temporary tables:
>
> table A contains the following columns:
>
> buy_currency sell_currency buy_amount sell_amount
> JPY USD 100. 1.00
> USD JPY 2.00 200.
>
>
> The final answer should be:
> currency buy_amt sell_amt
> JPY 100. 200.
> USD 2.00 1.00
>
> The actual query will be a sum of all currencies grouped by currency.
>
> Any suggestions will be helpful.
>
> Thanks.
> AG
What is the due date for turning in this assignment? Received on Thu Oct 17 2002 - 00:34:18 CEST