Re: Select First 500 Rows of a Table

Hello all,

Thanks for responding.

It seems Oracle keeps track of records\rows internally using ROWNUM. So for all those in a simliar situation try something like this:

SELECT * FROM mytable WHERE rownum <= 500

-Michael Received on Wed Aug 18 2004 - 05:30:15 CDT