A better way to execute this query?

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;

    ROWNUM

        20
        21
        22
        23
        24
        25
        26
        27
        28
        29
        30

    ROWNUM

        31
        32
        33
        34
        35
        36
        37
        38
        39

20 rows selected.

--



==

            "... big dogs landing on my face ..."
				   -- Robin Williams, 'Good Morning, Vietnam'

Eric White		Internet: white_at_titan.tsd.arlut.utexas.edu
Applied Research	Phone:	  (512) 835-3621   FAX: (512) 835-3416/3259
  Laboratories		Fedex:	  10000 Burnet Road, Austin, Texas 78758-4423
University of Texas	Postal:	  P.O. Box 8029, Austin, Texas 78713-8029


==