以自动增长的ID作为主键,注意:ID可能不是连续的 假如是31到40条记录 解1:select top 10 * from A where id not in (select top 30 id from A) 解2:select top 10 * from A where id > (select max(id) from (select top 30 id from A )as A) 原来是零分 my god 好歹给几分吧
select top n * from (select top m * from tablename order by columnname) a order by columnname desc
将m笔插入到临时表 select top m * into 临时表 from tablename order by columnname 再取n条结果 set rowcount n select * from 表变量 order by columnname desc
一个小小的建议,提问给点分,否则没回复的哦。
解1:select top 10 * from A where id not in (select top 30 id from A) 解2:select top 10 * from A where id > (select max(id) from (select top 30 id from A )as A) 原来是零分 my god 好歹给几分吧
from tablename order by columnname) a
order by columnname desc
select top m * into 临时表
from tablename
order by columnname
再取n条结果
set rowcount n
select *
from 表变量
order by columnname desc