sql server如何查询一个表的 第2条数据

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