The following will group all the clients togther with there oldest account first. However, it will not display the client with oldest account first, if you want that, go with David's approach:
select * from temp group by clt_code, date
The output looks like:
1999.12.31 AA
2000.12.31 AA
1997.01.01 BBB
2000.02.22 BBB
1996.01.01 FFF
1998.01.01 FFF
1999.01.01 FFF
2000.02.24 FFF
Regards.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao
