Hi there, I have a table bank_posn. The schema is given below: BRANCH varchar(50), DT varchar(50), HDFC varchar(50) , AXIS varchar(50) , IDNT int IDNT is the identity column. Now suppose I have the following rows: mumbai 2011-07-29 5000 3000 1 mumbai 2011-07-29 4000 3000 2 delhi 2011-07-29 5000 3000 3 delhi 2011-07-29 7000 3000 4 Now I want to display the following results: mumbai 2011-07-29 4000 3000 2 delhi 2011-07-29 7000 3000 4 Please help me to sort out my problem. I have tried the following query but I'm clueless: SELECT * FROM BANK_POSN INNER JOIN (SELECT MAX(IDNT), BRANCH, DT, HDFC, AXIS, ICICI, BOB, PNB, FEDEBNK, IOB, CENTRALBNK, TOT FROM BANK_POSN GROUP BY BRANCH) T ON BP.BRANCH = T.BRANCH AND BP.IDNT = T.IDNT ORDER BY BP.IDNT