SQL Query

[Anand Kumar N]

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