select statement

i have given following statement.

select * from BSID.

however, i want to select on the basis of record ranges

e.g.

select * from BSID where rowid <= 10000

select * from BSID where rowid > 10000

can i do that ? or is there any other option

Regards,

Santosh.