分页查找SQL

select * from (
	select rownum as rn ,t.* from
	(
		select s.* ,c.classes_name from t_student s join t_classes c on s.classes_id = c.classes_id
	) t where rownum <= pageNo * pageSize
) where rn > (pageNo - 1) * pageSize