Re: Analytics or not
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: zoran_martic@xxxxxxxxx
- Date: Fri, 8 Apr 2005 16:21:32 -0400
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
> --
> //www.freelists.org/webpage/oracle-l
>
--
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
Other related posts:
