Re: Analytics or not
- From: Martic Zoran <zoran_martic@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 13:45:26 -0700 (PDT)
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@xxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
