题目

查数据库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 EditDate