SQL Server 2005 中如何取出除第一行以外的所有行

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 )