table1有100条记录

[awjx]

table1有100条记录，现我想分页查询，即每页显示10条记录，用SQL语句可以做到吗？怎样写？

[pengdali]

select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20

[pengdali]

select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20

[hjb111]

能：

declare @n int
declare @s varchar
set @n=1
set @s='1'
select identity(int,1,1) as idd,* into #t from table1
while @n<>91
begin
exec('select * from #t where '+@S+' between '+@s+'10'')
set @n=@n+10
set @s=cast(@n as varchar(3))
end

go

[CrazyFor]

查询N-M条记录。
select IDENTITY(int,1,1) as iid,* into #temptable from yourtable
select top M-N * from #temptable where iid>=N

OR:

select top M-N * from yourTable where id not in(select top N-1 id from table)
ID为表具有唯一值的任何字段

[awjx]

我还是有一点不懂，因为每的行数是一个输入参数@start
即接受程序的@start参数，返回每页@start行！