Re: Analytics or not

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 8 Apr 2005 13:45:26 -0700 (PDT)
Message-ID: <20050408204526.72579.qmail@web52608.mail.yahoo.com>

Christo,

It is the similar:

select col1
  from (select col1, max(nbr) over (partition by col1 order by col1)
mnbr

          from (select col1, row_number() over (order by col1) nbr

                  from tbl))

 where mnbr<10;

Regards,
Zoran

• Christo Kutrovsky <kutrovsky.oracle_at_gmail.com> wrote:
  > I didn't see Mike's answer, can you or Mike forward
  > it ? I am curious
  > to see his solution.
  >
  

  ---

Do you Yahoo!?
Yahoo! Personals - Better first dates. More second dates. http://personals.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 08 2005 - 16:49:20 CDT