Oracle-L: Re: SQL Query

From: Mikhail Ivanov <mivanov_at_tdera.ru>
Date: Thu, 03 Oct 2002 00:48:24 -0800
Message-ID: <F001.004DEF23.20021003004824@fatcity.com>

3 ïËÔÑÂÒØ 2002 12:03, ÷Ù ÎÁÐÉÓÁÌÉ:
> 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
>

select NAME, 5-AGE AGE from test;
Are you want that or "general" revers of AGE ?

> Can any body pl. help me.
>
> Anand Kumar
> ITW Signode India Ltd

-- 
÷ÓÅÇÏ ÈÏÒÏÛÅÇÏ
íÉÈÁÉÌ é×ÁÎÏ×
ÿóåy«±ç…ê~'"jS‘
ü¸¬´k«»ÿÚØ§¶¦zËàN
âÉnuæ¥Šwœ¢{ZŠx§ƒõ
I_at_ND

Received on Thu Oct 03 2002 - 03:48:24 CDT