日期:2014-05-18 浏览次数:20548 次
select id from (select row_number()over(order by getdate()) as rownum,* from tbl)a where rownum>=2
------解决方案--------------------
select * from #test1
except
select top 1 * from #test1
------解决方案--------------------
select ID from ( select ROW_NUMBER() over(order by id )rn,* from #test1 )a where rn>1
------解决方案--------------------
select * from #test1
except
select * from #test1 where id=1
--or
select * from #test1
except
select top 1 * from #test1