sql server怎么查询一个表的 第2条数据?
sql server怎么查询一个表的 第2条数据?新手求高手帮帮忙

[解决办法]

SQL code

select top 1 * from Scoreproduct where scoreproduct_id<>(select min(scoreproduct_id) from Scoreproduct )
[解决办法]
SQL code
select top 1 * from  (select top 2 * from tablename order by scoreproduct_id ) a order by scoreproduct_id  desc