Re: Top 10 recordsets

In O8i you can now use ORDER BY in a view - ie also in a FROM clause (maybe O8 8.0 too but I can't remember)

ie select *

      from (select *
              from xxxx
             order by column desc)
     where rownum <=10

Wayne Linton

TurkBear wrote:
>
> Note: The 10 records returned will NOT be the TOP 10 if by top you mean those
> with the highest values for some particular field...Rownum <= 10 returns the
> FIRST 10 records from the database ...
>
> "Marcello Cecci" <mcecci_at_seldat.it> wrote:
>
> >select * from <table> where ROWNUM<=10;
> >
> >Bye
> >
> >Jens Seifert <jens.seifert_at_allianz.de> wrote in message
> >news:950007477.664453_at_rsx2668...
> >> Hello,
> >>
> >> how can I select in a SQL-Query the top10 recordsets from a table?
> >> I use ORACLE8.
> >>
> >> Thanks, Jens
> >>
> >>
> >>
> >>
> >
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----

--
Wayne Linton
ORA*DBA Systems Consulting Ltd.
ora-dba_at_home.com Received on Thu Feb 10 2000 - 23:52:17 CST