select top 记录数 ID,field1,field2,....... FROM TableName WHERE 查询条件and ID not in(select top N ID FROM TableName WHERE 查询条件) |
select top 记录数 ID,field1,field2,....... FROM TableName WHERE 查询条件and ID not in(select top N ID FROM TableName WHERE 查询条件) |