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_at_yahoo.com> 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_at_gmail.com>
> 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