分页

select * from articles limit  (pageNo-1)*pageSize,pageSize

select * from 
	(select rownum r,* from 
			(select * from articles order by posttime desc) 
			where rownum <= pageNo*pageSize) 
	tmp
 where r>(pageNo-1) *pageSize;