关于oracle中的SQL语句转化为sqlserver中的SQl语句的问题

Question

select * from (select rownum as r,t.* from   
                            (select emp.* from emp order by hiredate desc) t where rownum<=10)  
                                      where r>5;
谁能把这句话转化为sql server中可以运行的sql语句

Answer 1

select * from (select rownum as r,t.* from

(select top 10 emp.* from emp order by hiredate desc) t )

where r>5;