select top 71 * from tab where id>(select top 9 id from tab )
设ID为你TAB表的标识列.或大小是顺序排下来的.SELECT TOP 71 * FROM Tab WHERE ID>(SELECT MAX(ID) FROM (SELECT TOP 9 * FROM Tab ORDER BY ID) x) ORDER BY ID或者SELECT TOP 71 * FROM Tab WHERE ID NOT IN(SELECT TOP 9 ID FROM Tab ORDER BY ID) ORDER BY ID
--沒有ID,就臨時表 select [id]=identity(int,1,1),* into #temp from Tab select c1,c2,c3... from #temp where [id] between 10 and 80
如有自增量则可按上做 如果没有自增量则: select * ,identity(int,1,1) as id into # from tb select top 71 * from (select top 80 * from # order by id) a order by id desc
select top 71 * from Tab where id not in (select top 9 id from Tab)
where id>(select top 9 id from tab )
select [id]=identity(int,1,1),* into #temp from Tab
select c1,c2,c3... from #temp where [id] between 10 and 80
如果没有自增量则:
select * ,identity(int,1,1) as id into # from tb
select top 71 * from (select top 80 * from # order by id) a order by id desc