On Thu, Feb 09, 2006 at 09:51:13PM -0500, Stephen Frost wrote: > * David Rio Deiros (driodeiros@xxxxxxxxx) wrote: > > Now I have to redefine my query because I want to get the second > > output but keeping the group_id. Ideas and suggestions are welcome. > > You might want to look at 'distinct on'. I am reading about it right now. It sounds that it will make it. Thanks guys for your help, David