Version Flag

Guys,

I have following scenario where I need to populate version flag based on the partyid, count and seq columns.

Here is it how it should populate for each new count of a partyid the max(seq) should be versioned as 1

For example

PARTYCOUNT SEQ VERSION
_________________________________________________
10011 1
10111 0
10112 1
10121 0
10122 0
10123 1
10231 1

Is there any way to populate this version flag.

Any sugggestions and inputs would help

Thanks