Re: Complicated query: searching for results within results.

phreaker wrote:
> Hi, I have a query that I need to do that I've been thinking about, and
> I am stuck at this point.
>
> Table 1 has columns A, B, and C
>
> For a given A, I need to figure out whether there exists <B,C> pairs
> that have the same B, but different C. For a given A, there are a
> potentially many Bs and many Cs.
>
>
> So for a given A, if there are these results in the table:
>
> B C
> 1 5
> 1 100
> 2 4
> 2 4
>
> I need to return true, since <1,5> and <1,100> have same B, but
> different C.
>
> Thanks!
> David

Please, everyone, remember that some of these queries are from students. Provide hints ... not solutions.

I'm not saying phreaker is a student ... but please think carefully about what is being asked before answering.

Thanks.

-- 
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