Re: Partial distinct - how?

Roy Brokvam schreef:
>
> To fetch the data that you want, take a look at the GROUP BY clause in the
> SELECT section of your SQL reference.
>
> To avoid repetition of person.id, take a look at the BREAK command in your
> SQL*Plus reference.
>

Yes, I could do that. Only I need to read in extra data on the person (name/
adress etc) and I can't if I use a GROUP BY. Apparently I simplified my example a bit too much...

But thanks anyway Roy; I never looked at the BREAK much but will do so now :-) Received on Fri Sep 24 1999 - 03:58:58 CDT