using GROUPing might well be appropriate here, and possibly a subquery.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"drukqs" <invalid.drukqs_at_NOpandoraSPAM.belgie> wrote in message
news:Xns9376A3D2159E0invaliddrukqspandora_at_195.130.132.68...
> Daniel Morgan wrote in news:3EBBACEF.39C32FB7_at_exxesolutions.com:
>
> > Then you probably want to do something involving the MAX function and
> > in your WHERE clause use the BETWEEN operator.
>
> This is the situation. Lets say there are 20 computers sold with the
number
> 1, 10 with the number 2 and 9 with the number. I need to say in a field
> that computer 1 is sold the most.
Received on Fri May 09 2003 - 09:36:12 CDT
