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� "�,P��i��0�}���`.�+2)!j)H��較DNh�jz/�j��jТ�#^�
+�'��' ��|�9ӝa���
+0}�\�ܜ�d��8�����'�x�1���x%��Z�� n,�)���ǬN�D0�Dʋ���_~�&������x%��lzwZ�C�Y��Ơz� ��F���j�"�'(�z-xE�
+ ;)zYb�
.+-��jwb��^��,j�86"��nu楊w��{Z�x��CRP� "�.���ڙ� ����x%��r����hm�ޚ��u�虊.�����,zwm���,�(�f�u�+��^�)ߢ���*'�) ���r���x
