sql: between and

microsoft sql server:
SELECT * FROM (
    SELECT t.*, ROWNUM rn
    FROM hr.bi_history t
)  WHERE rn BETWEEN 5 AND 10;


navicat sql server:

select * from (
　　　　select *, ROW_NUMBER() OVER(Order by slabid ) AS RowId from [dbo].[T_GPKCMX]
　　) as b

where RowId between 6 and 10;