Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Complex SQL
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 - 01:10:08 CST
![]() |
![]() |