Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: max occurences
Hi,
if I understand the OP correctly, he /she is looking for the max. occurance of the same value in the column 'number' (eek, bad name!). If I'm right, he /she has to look for 'GROUP BY' and 'HAVING'.
And to you, '--B': please try to ask questions in a manner that you would like to be asked in. And provide OS, RDBMS, used tools etc.
hth,
Guido
"Jim Kennedy" <kennedy-family_at_attbi.com> schrieb im Newsbeitrag
news:LmJJ9.317498$QZ.47356_at_sccrnsc02...
> what about using max?
> select number from myTable where dummycol=max(dummycol) order by number;
> (in case of ties)
> Jim
> > "--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 Thu Dec 12 2002 - 03:11:02 CST