RE: SQL Query

[Naveen Nahata]

why do u want such a query? -----Original Message----- From: Anand Kumar N [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Subject: SQL Query 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