从一个表中取出从第N行到第M行的数据

[rfx007]

RT，说明一下这个表是没有主键的，最后能用一行SQL语句写出来，不知道能不能，我想了下貌似写不了

[wuzhanhui]

SELECT TOP m-n+1 * FROM 表名 WHERE id NOT IN(SELECT TOP n-1 id FROM 表名)



id 为表名表的关键字，不一定是主键，只要id能够自动增长或者是手动增长都可以

[哥本哈士奇]

一行够呛。
怎么的也得用游标吧。

[chenyun122]

select *
from (
select ROW_NUMBER() OVER ( ORDER BY PersonnelGUID) AS RowNumber,*
from 表
) T
where RowNumber > N and RowNumber < M

[chenyun122]

select *
from (
select ROW_NUMBER() OVER ( ORDER BY 随便一个列名) AS RowNumber,*
from 表
) T
where RowNumber > N and RowNumber < M

[宇峰科技]

1.
select top m * from tablename where id not in (select top n * from tablename)

2.
select top m * into 临时表(或表变量) from tablename order by columnname -- 将top m笔插入
set rowcount n
select * from 表变量 order by columnname desc

3.
select top n * from
(select top m * from tablename order by columnname) a
order by columnname desc


4.如果tablename里没有其他identity列，那么：
select identity(int) id0,* into #temp from tablename

取n到m条的语句为：
select * from #temp where id0 >=n and id0 <= m

如果你在执行select identity(int) id0,* into #temp from tablename这条语句的时候报错,那是因为你的DB中间的select into/bulkcopy属性没有打开要先执行：
exec sp_dboption 你的DB名字,'select into/bulkcopy',true


5.如果表里有identity属性，那么简单：
select * from tablename where identitycol between n and m

[guyehanxinlei]

http://topic.csdn.net/u/20090119/16/c1e3660a-fd24-46b2-b61f-956a7c3539b8.html