Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!news.webusenet.com!newsfeed.ision.net!news.is-europe.net!ision!not-for-mail
From: "Guido Konsolke" <Guido.Konsolke@triaton.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: max occurences
Date: Thu, 12 Dec 2002 10:11:02 +0100
Organization: Ye 'Ol Disorganized NNTPCache groupie
Lines: 25
Message-ID: <1039684026.634096@news.thyssen.com>
References: <MQCJ9.5149$Vf3.55294@vixen.cso.uiuc.edu> <v5DJ9.5151$Vf3.55100@vixen.cso.uiuc.edu> <LmJJ9.317498$QZ.47356@sccrnsc02>
NNTP-Posting-Host: 149.211.49.31
X-Trace: goliath.news.is-europe.net 1039684263 10580 149.211.49.31 (12 Dec 2002 09:11:03 GMT)
X-Complaints-To: abuse@is-europe.net
NNTP-Posting-Date: 12 Dec 2002 09:11:03 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Cache-Post-Path: news.thyssen.com!unknown@170.56.164.197
X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/)
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:90466
X-Received-Date: Thu, 12 Dec 2002 02:10:40 MST (news.easynews.com)

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@attbi.com> schrieb im Newsbeitrag
news:LmJJ9.317498$QZ.47356@sccrnsc02...
> what about using max?
> select number from myTable where dummycol=max(dummycol) order by number;
> (in case of ties)
> Jim
> > "--B" <akshard@vsnl.com> wrote in message
> > news:MQCJ9.5149$Vf3.55294@vixen.cso.uiuc.edu...
> > > how to return a row with max occurences of some value in one column?
> > >