从表中取出第 M 条到第 N 条的记录（如N=M+10）
select top N-M+1 * from [tableName] where (id not in (select top M-1 id from [tableName]))
select top N-M+1 * from [tableName] as a where not exists (select * from (select top M-1 * from [tableName] order by id) b where b.id=a.id ) order by id
注意
上述语句不能取从第1条到第N条的数据（即M=1时失效），因为select top N …… 中N必须从1开始（参考：数据库读取前几条记录的SQL语句大全）
此问题的解决办法：要取第1到N条的记录，需要使用select top N …… 解决。
取数据库第20到第30条中间的十条记录的sql语句
select top 10 * from [tableName] where id not in (select top 20 id from [tableName] order by id)
删除前10行
delete from [tableName] where id in(select top 10 id from [tableName])
删除10-20条
delete from [tableName] where id in(select top 20 id from [tableName]) and id not in(select top 10 id from [tableName])
