select * from （select *,row_number()over(order by 列) as Row from table）a where row>1


或用唯一性的列在where条件是排除

------解决方案--------------------

select * from table where id not in(select id from (select top(1)* from table)as a )