SQL查询 从第N条记录开始显示M行

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) Twhere rn between N and M 

Mysql

select * from tablename limit N,M

Oracle

select T.* from(  select *,rownum rn from tablename ) Twhere rn between N and M