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
) 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