Re: Select Family, First (Name) from ... group by Family

Try this:

Select Family,Max(Name) from People Group By Family. Thomas.

"Patrick Joyal" <please.reply_at_to.the.newsgroup> wrote in message news:38b4438f_at_news...
>
> here's an example to understand my problem.
>
> I have a table People containing 2 columns : Family and Name
>
>
> Family Name
> ------------- ------------
> Smith John
> Smith Roger
> Smith Bob
> Doe Arthur
> Doe John
> Souvlaki Angie
> Souvlaki Benny
>
>
> in Access, if I want 1 member from each family, I use this :
>
> Select Family, First (Name)
> from People
> Group By Family
>
> results :
>
> Family Name
> ------------- -----------
> Smith John
> Doe Arthur
> Souvlaki Angie
>
>
> How could I do this in Oracle ?
>
> merci
>
> Patrick
>
>
Received on Wed Feb 23 2000 - 14:53:11 CST