sqlserver 分页查询：

select top 5 * from file_info where fileId not in(select top 0 fileId from file_info order by pubTime desc) order by pubTime desc

oracle 分页查询：

select * from   (  select A.*, rownum RN   from (select * from askInfo) A   where rownum <= 40  )  where RN >= 21