删除多余数据,只保留前10条记录的SQL语句 delete from TableName where id not in (select top 10 id from TableName order by id)