Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: QUERY (top 10)
check the query I sent you ... I am hoping you are on version that
supports analytical functions ...
Raj
On 5/16/05, Seema Singh <oracledbam_at_hotmail.com> wrote:
> Sorry Raj,
> the output would be like
> date domain spam
> > > 05/05/05 hotmail.com 120
> > > 05/05/05 yahoo.com 110
> > > 05/05/05 abc.com 99
> > > 05/05/05 def.com 80
> > > 05/05/05 mnpo.net 79
> ......................................... like that upto 10
> > > --------------------------------------------------
> > > 05/06/05 yahoo.com 300
> > > 05/06/05 def.com 250
> > > 05/06/05 zer.com 200
> ..................................like that upto 10
>=20
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 16 2005 - 10:38:41 CDT
![]() |
![]() |