sqlserver 2000
select top M * from tablename where id not in
(select top N id from tablename order by id asc)
sqlserver 2005以上
select T.* from
(
select *,row_number() over(order by id) as rn from tablename
) T
where rn between N and M
Mysql
select * from tablename limit N,M
Oracle
select T.* from
(
select *,rownum rn from tablename
) T
where rn between N and M