Re: QUERY (top 10)
- From: rjamya <rjamya@xxxxxxxxx>
- To: Seema Singh <oracledbam@xxxxxxxxxxx>
- Date: Mon, 16 May 2005 10:33:37 -0400
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@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
