TRY THIS :
SELECT NAME, 4-AGE+1 FROM test;
- Naveen Nahata <naveen_nahata_at_mindtree.com> wrote:
> why do u want such a query?
>
> -----Original Message-----
> Sent: Thursday, October 03, 2002 1:33 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have a table test((NAME VARCHAR2(10),AGE
> NUMBER(2));
>
> data of the table is
>
> NAME AGE
> ---------- ---------
> ANAND 1
> BALU 2
> CHANDU 3
> DAVID 4
>
>
> I want a query which give me the result as
>
> NAME AGE
> ---------- ---------
> ANAND 4
> BALU 3
> CHANDU 2
> DAVID 1
>
> Can any body pl. help me.
>
> Anand Kumar
> ITW Signode India Ltd
>
>
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ASHRAF SALAYMEH
INET: ashraf_salaymeh_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Oct 03 2002 - 06:58:24 CDT
