select top 1 item from table where item not in (select top 1 item from table order by item desc)
select top 1 * from (select top 3 * from tb1 order by item asc)A 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 行) */
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 行)
*/