select 马上结贴

[bean_sql]

假设有表格
test（id1 varchar(50),id2 int）
0001 1
0002 2
0003 3
0004 4
0005 5


如何得到表里面的“第二条”数据 0002 2 不通过id1 和id2 字段~！

[TheGodOfGods]

昨天也有个类似的帖子

[aaron_gl]

select c.* from (select row_number() over(order by select 1) as 'cnt',* from table) as c where c.cnt=2

[meinvqiujiu]

select top 1 * from (select top 2 * from test order by id1 desc) as table1

[shixixi1987]

if exists(select * from sysobjects where [name]='tb')
drop table tb
go
create table tb
(
id1 varchar(50),
id2 int
)
go
insert into tb(id1,id2)
(
select '0001',1 union
select '0002',2 union
select '0003',3 union
select '0004',4 union
select '0005',5
)
go
select * from tb
go
select top 2 IDENTITY(INT,1,1) as num,* into #test from tb
go
select top 1 id1,id2 from #test order by num desc
go

id1                                                id2
-------------------------------------------------- -----------
0002                                               2

[百年树人]

如果不通过排序取第二条记录，似乎没什么意义

[水族杰纶]

非要这样
游标吧

[songsuqing0504]

if object_id('test') is not null
drop table test
create table test(id1 varchar(50),id2 int)
insert into test
select '0001',1 union all
select '0002',2 union all
select '0003',3 union all
select '0004',4 union all
select '0005',5
go

select id1,id2
from
(select id1,id2,row_number() over(order by getdate()) cn from test) w
where w.cn=2
--结果------
id1 id2
0002 2

[hao1hao2hao3]

参考帖子
http://topic.csdn.net/u/20100803/18/bf3a373f-711a-4898-ae05-b83624b59b4e.html
四楼，本人的回复！