select top 20 * from table where id not in ( select top 10 id from table ) 转载于:https://www.cnblogs.com/zqlohno/p/3804070.html