select BRANCH, DT, HDFC,AXIS, Max(IDNT) as IDNT from banj_posn group by BRANCH; /* untested but should work for your example */ On Mon, Aug 1, 2011 at 12:41 PM, The sherminator <steve.kim41@gmail.com>wrote:

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 _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke