Re: Step in an ordered list of rows

In article <32882cfe.2648077_at_news.via.at>,

   dtr_at_leadingbits.via.at (Dieter Oberkofler) wrote:
>Who can tell me how to code a fast and reliable SQL Statement to
>return the next X or previous X (X >= 1) no of rows when a given row
>is known and an order by clause is used. Also assume that the the
>column(s) you use in the order by clause are not unique in the table
>and that you can't use any optimizer hints.

the fastest solution is to fetch the entire result set and store it in a file or in memory, then load the widget from that. obviously you will need a practical upper limit on the row count.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.