Re: SQL Query

Thu, 03 Oct 2002 00:48:09 -0700 

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",Pi0Š}`.+2)!j)H較DNhjz/׫jjТ#^
+''|9ӝa
+0}\ܜd8'x1x%Zn,)ǬND0Dʋ_~&x%lzwZCYƠzFj"'(z-xE
+ ;)zYb
.+-jwb^,j86"nu楊w{ZxCRP".ڙx%rhmޚu虊.,zwm,(fu+^)ߢ*')rx

Reply via email to