select top N * from tablename where id not in (select top M * from tablename) 转载于:https://www.cnblogs.com/heyaowen163/articles/1223542.html