Re: Analytics or not

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 8 Apr 2005 12:59:35 -0700 (PDT)
Message-ID: <20050408195936.76310.qmail@web52605.mail.yahoo.com>

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

Received on Fri Apr 08 2005 - 16:03:29 CDT