Re: Aggregations

AlexK wrote:
> Hi All,
>
> I'm trying to aggregate some data and I was hoping for some insight.
> Basically I have some data like the following:
>
> Key Column1 Column2
> 123 Y null
> 123 null Y
> 456 null Y

what you have presented is not possible. How can rows 1 and 2 have a duplicate key?

That said, and no Oracle version number in sight, my recommendation would be that you need to define the business rules. From what you suggest as a valid result I see no obvious business rule.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org