SPLITTING TABLE results ... plz

[Anon]

hi
i wanna ask...
we can use LIMIT in our MySql database. means we can fetch number of records as our need like :
select from table LIMIT 0,10
this query will fetch only 10 records
but now my question is this that can we use this kind of query with MS Access OR MS SQLServer ???
if yes then ??
or if there is any other way to do this ... please tell me.
and as we use in every database the keyword TOP means(select top 4 from table)
it means that it will select top 4 records its ok but how i will get remaining records ???
thanks for ur support
shahid

[sarahk]

if you have your data ordered or selected wisely then it lets you select where recno() < 10

[Anon]

i mean to say i don't want to use where clause... or suppose that i m using where clause i.e where id < 10 but suppose this generates 200 results that has ID less than 10 then how can i divide my 200 results into 50 records each page ???
thanks
shahid