Re: MAX(COUNT(*))?

"Clairwil" <clairwil_at_hotmail.com> wrote in message news:OAd_9.63989$YG2.1793074_at_twister1.libero.it...
> From the table
>
> Computer (IdComputer, model, IdDealer, DealerAddress)
>
> I need to find which dealer has sold most computers;
> I can count how many computers they have sold each one, I can order them,
> but I can't find only the bestseller, the maximum value in COUNT(*)
column!!
>
> SELECT IdDealer, COUNT(*) FROM Computer
> GROUP BY IdDealer
>
> ORDER BY IdDealer, desc;
>

1.
select * (
 select * (
  SELECT IdDealer, COUNT(*) c FROM Computer   GROUP BY IdDealer
 ) order by c desc
) where rownum <= 1

2.
select * (
  SELECT IdDealer, COUNT(*) c FROM Computer   GROUP BY IdDealer
) where c in (select max(c) from (SELECT COUNT(*) c FROM Computer   GROUP BY IdDealer)) Received on Thu Jan 30 2003 - 19:22:53 CET