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