Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Fri Apr 08 2005 - 16:25:26 CDT
![]() |
![]() |