Re: QUERY (top 10)

From: rjamya <rjamya_at_gmail.com>
Date: Mon, 16 May 2005 10:33:37 -0400
Message-ID: <9177895d0505160733491989fa@mail.gmail.com>

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

> What would be query for that kind of output?
> thanks

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 16 2005 - 10:38:41 CDT