sqlserver 和 Mysql 的前几条的查询

Mysql

select * from tablename where id<{0}  order by id desc limit 0,8

-------------------------

转换为 sql

m 0
n 8

select top (n-m+1) id from tablename
where id not in (
  select top m-1 id from tablename
)