oracle 分页查询和sql server 分页查询 的sql语句

oracle：

SELECT * FROM (

SELECT TEMP.* ,ROWNUM RN FROM ( 表) TEMP WHERE ROWNUM <=currentPage * perPageRows ) WHERE RN >  (currentPage - 1) * perPageRows

sqlserver：

SELECT * FROM (
        SELECT TEMP.*,ROW_NUMBER() OVER (ORDER BY ID) AS ROWNUM FROM 
            ( 表) TEMP
            ) 
    T WHERE T.ROWNUM >0 AND T.ROWNUM<=10