Re: A better way to execute this query?

In article <WHITE.92Oct26125702_at_macaw.titan.tsd.arlut.utexas.edu>, white_at_titan.tsd.arlut.utexas.edu (Eric White) wrote:
>
> folks, my SQL query evaluation knowledge is a bit rusty. The Select
> statement below works, but is inefficient. Is there a better method
> of selecting items between ROWNUM ranges than I do below?
>
> SQL> select rownum from tacfire_rx_data_attributes
> 2 where rxa_retry_count is not null and rownum < 40 minus
> 3 select rownum from tacfire_rx_data_attributes
> 4 where rxa_retry_count is not null and rownum < 20;

select rownum from tacfire_rx_data_attributes

   where rxa_retry_count is not null
   and rownum between 20 and 40;

                             
               Devan F. Dewey | Senior Systems Analyst
          CenterLine Software | dewey_at_centerline.com
            10 Fawcett Street | "Leme esplain - no dere is
          Cambridge, MA 02138 | too much. Leme sum up."
                                       -Inigo Montoya