Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: max occurences

Re: max occurences

From: --B <akshard_at_vsnl.com>
Date: Wed, 11 Dec 2002 14:17:07 +0530
Message-ID: <v5DJ9.5151$Vf3.55100@vixen.cso.uiuc.edu>


e.g.

number dummycol

1                     10

2                         5

1                         7

1                         6

3                          3

The result should give me 1.

"--B" <akshard_at_vsnl.com> wrote in message news:MQCJ9.5149$Vf3.55294_at_vixen.cso.uiuc.edu...
> how to return a row with max occurences of some value in one column?
>
>
>
>
Received on Wed Dec 11 2002 - 02:47:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US