Re: order by, rownum and more

There is still a semantic problem here..There is no such thing as THE 6th record.. That could be any record in the table depending on how you structure the query that retrieves it... If the 6th row ( or any particular row - since there is no 6th row in the stored data) is significant why not just add a rownumber field and populate it when it is inserted? then you could access it, for whatever reason, directly: where rownumber = 6;  

Brian Murphy <rudie_at_wpi.edu> wrote:

>Hello,
>
>I'm currently trying to do some order based queries with oracle. Yes, I
>know, relational databases aren't order sensitive, but I'm supplying a
>order as a column value.
>
>I am attempting to order by my columns, then return the 6th row, with
>oracle's ROWNUM. But so far, I can only get the appropriate result if my
>query resembles the following:
>
> (select * from (select * from my_tab order by b) where rownum <=6)
> minus
> (select * from (select * from my_tab order by b) where rownum <6);
>
>This will return the 6th row. But it must be quite expensive. Any idea
>on how I could speed up this query, while still retrieving the proper
>result?
>
>I've heard mention of oracle extensions that mention order/time/rank, but
>haven't found any documentation. Perhaps that would help me? Anyone have
>a link, or info on that?
>
>Thanks.
>
>brian
>
>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Aug 08 2002 - 14:14:58 CDT