Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: A tricky query question...
Looks more like a combination of a many-to-many problem maybe with a
"rownum" or "count" and a "group by" with a "having" clause. Looks like it
is intended to be comprehensive as if part of a final exam.
<jk_man_at_my-deja.com> wrote in message news:823sgg$q9s$1_at_nnrp1.deja.com...
> I'm doing this college assignment and I just can't solve this query - it
> seems straigth forward at first, but it isn't.
>
> OK...
>
> I'm given a table of sports activites (call this sports) and another
> table of holiday resorts (call this resorts) where each resort has
> numerous sports facilities. i.e. each resort has several rows, each one
> describing a different sports facility.
>
> Now the query is:
>
> Select all those resorts that have facilities for *all* sports
> activities (as listed in sports) and ignore the other resorts. I think
> I'm supposed to use 'MINUS', but there may be other ways also.
>
> Anyway suggestions appreciated,
> Jack.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 01 1999 - 13:45:29 CST