Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Receiving Query result...
To get to the last ten rows you will have to do a full tablescan if you
don't have a search criteria.
I don't really understand what you are trying to achieve here?
Hans Duijn wrote in message <6i1iui$erc_at_news3.euro.net>...
>Hi,
>
>To all the SQL gurus. Is there a way to receive the last ten rows from a
>selection (based upon a cursor). I know I can use ROWNUM for that purpose
>but when I want the result to be sorted I have to create a VIEW and use
>GROUP BY. As I said, this works but is rather slow an lot of work around.
>
>Anyone an idea?
>
>Thanks
>
>
Received on Tue Apr 28 1998 - 03:24:46 CDT
![]() |
![]() |