取数据问题
表只有1个字段
item
4444
333
222
1111
我想取出上面数第2个怎么取?谢谢
[解决办法]
select top 1 item from table where item not in (select top 1 item from table order by item desc)
[解决办法]
select top 1 item from table where item not in (select top 1 item from table order by item desc) order by item desc
[解决办法]
create table tb(item int)
insert into tb values(4444)
insert into tb values(333)
insert into tb values(222)
insert into tb values(1111)
select top 1 * from tb where item not in (select top 1 * from tb)
drop table tb
/*
item
-----------
333
（所影响的行数为 1 行）
*/
