Re: Partial distinct - how?

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.

--
Roy Brokvam

Theory is when you know why it doesn't work. Practice is when it works, but you don't know why. We combine theory and practice;
It doesn't work, and we don't know why. Received on Thu Sep 23 1999 - 04:31:33 CDT