一道面试题!

[zhnzzy]

Let’s say we have a database with 1 one-column table. It contains 1000 same records. Could you please give at least 1 solution to help get records between line 5 and 7. No line number, row id or index etc

[xyq1986]

select top 7 * from table
添充到DataReader，
int n=5;
while(n--)
reader.Read();
while(reader.Read())
现在就是要的了

[Zine_Alone]

Mark

[liujia_0421]

DataReader读出..

或者填充到一个DataTable中,然后取出5-7条..

[landy_shasha]

刚把题意翻出来，不好意思，呵呵
楼上真快

[coowoo]

It contains 1000 same records.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
取第一条就是了，反正都一样

[xyq1986]

这题考察的应该是取数据的方法吧，不是要结果

[Zine_Alone]

--测试数据
Create Table Test
(
Col1 nvarchar(32)
)

insert into Test values('1')
insert into Test values('1')
insert into Test values('1')
insert into Test values('1')
insert into Test values('1')
insert into Test values('1')
insert into Test values('1')
insert into Test values('1')
insert into Test values('1')
insert into Test values('1')

--开始行
declare @RowStart int
select @RowStart=5
--结束行
declare @RowEnd int
select @RowEnd=7

declare @i int
declare @RowCount int

select @RowStart=@RowStart+1
select @RowCount=@RowEnd-@RowStart
select @i=0
declare my_cursor SCROLL cursor
for
select col1 from Test
--Open Cursor
open my_cursor

fetch ABSOLUTE @RowStart from my_cursor
while @i<@RowCount
begin
select @i=@i+1
fetch Next from my_cursor
end
close my_cursor
deallocate my_cursor

[rainyubin]

mark

[zwlippi]

不一定对吧
在Oracle中rowid,SQL Server就不太清楚了