李sir_Blog

摘要： 查数据库30-40条记录Select Top 10 * from Tablename Where 关键字段 Not In (Select Top 30 关键字段 from TableName Order By 排序字段) Order By 排序字段子查询查出前30条记录。查出10条记录并且不在前30个子查询中的记录即可select top 10 * from device where CreatedDate not in (select top 30 CreatedDate from Device order by EditDate) order by... 阅读全文