Given a table

name sequence otherColumns...
A 999
A 998
B 999
B 998
B 997
C 999

how can I get back only rows two five and six, plus their associated
other columns?
My immediate thought was to use GROUP BY and get the MIN of sequence,
but of course that wouldn't give me the other columns of that row.

Rick DeBay
Senior Software Developer
RxStrategies.net