limiting number of rows returned in sql query

Is there a way to limit the number of rows returned in a query?

For example, I have a system that has 2,000 records in it. I want to pull those records in a batch process 500 at a time with software that will do scheduled sql queries -- I just need to figure out how to limit the record numbers returned without changing the design to the database (its a third party app's database).

Thanks! Received on Fri Jun 21 2002 - 05:15:26 CDT