22,301
社区成员




select top 1 * from
(select top 2 * from tablename order by scoreproduct_id ) a
order by scoreproduct_id desc
select top 1 * from Scoreproduct where scoreproduct_id<>(select min(scoreproduct_id) from Scoreproduct )
set rowcount 2
select top 1 * from Scoreproduct order by scoreproduct_id desc
set rowcount 2
select top 1 * from tb order by scoreproduct_id desc
select id=identity(int,1,1),* into #tb from tb
select * from #tb where id=2