jumping to records

Is it possible to select all records from a table but to jump to a particular one?
for example suppose I want to retrieve all records from a table but I want to start somewhere in the middle.
If I execute
select * from employees where name='aaron' I will only get one record.
If I execute
select * from employees;
I will only get all the records and will have to retrieve many records before finding the one I am looking for.

Thanks a lot,

Aaron Received on Sun Jun 18 2000 - 00:00:00 CDT