Re: Analytics or not

I didn't see Mike's answer, can you or Mike forward it ? I am curious
to see his solution.

On Apr 8, 2005 3:59 PM, Martic Zoran <zoran_martic@xxxxxxxxx> wrote:
> Thanks a lot to Mike and Christo,
> 
> This solved it.
> 
> Wanted to see the solution and different ideas, but it
> looks no other way then this.
> 
> Regards,
> Zoran
> 
> --- Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
> wrote:
> > select ttt.*
> > from (
> >   select tt.*, max(cnt_t) over (partition by part)
> > as mx_p
> >   from (
> >     select t.*, count(*) over (order by num) as
> > cnt_t  from sample t
> > order by num
> >   ) tt
> > ) ttt
> > where  mx_p <= 10;
> 
> __________________________________
> Yahoo! Messenger
> Show us what our next emoticon should look like. Join the fun.
> http://www.advision.webevents.yahoo.com/emoticontest
> --
> http://www.freelists.org/webpage/oracle-l
> 


-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l

Other related posts: