这条分页语句有问题吗?
select * from (select row_.*, rownum rownum_ from (
select userinfo.id as "id"
from tbl_user_teacher teacherinfo,tbl_user_info userinfo
where 1=1
and teacherinfo.id = userinfo.id
and userinfo.status = 1
and userinfo.region_id is not null
order by userinfo.region_id asc ) row_
where rownum <= 20 )
where rownum_ >=11