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