SQL 索引分页

sql 分页索引：
例：
select TOP 3 *
from (select (Row_Number() over (order by FWriteTime desc)) as RowIndex,*  from table where id = '0B82E99F-BA1F-473B-88B5-F66316024432') A
where  RowIndex > (3*(1-1))

格式：
select TOP 显示记录数 *
from (select (Row_Number() over (order by time desc)) as RowIndex,*  from table_name where 条件表达式) A
where  RowIndex > (显示记录数*(当前索引页-1))