Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Complex SQL
Okay how about coaches for all players who are older than 30.
Ashish
<davide_at_yahoo.com> wrote in message
news:a8e9sg$qq75v$1_at_ID-18487.news.dfncis.de...
> Ashish Mittal <mittalashish_at_yahoo.com> wrote:
> > Do not denormalize. Imagine doing a query which finds out the coach for
all
> > players in the system :)
>
> That's easy: there is just one coach for every record, so you have
> to do just SELECT DISTINCT COACH FROM ....
>
> BTW, you can enforce the 12-players-rule with a trigger.
>
> Davide
Received on Wed Apr 03 2002 - 09:35:26 CST