如题，sql server 2005没法用row_number()，有什么方法可以实现？求高人解答~
------解决方案--------------------
- SQL code
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 )