select v_id,v_name,v_status
from (select rownum rw,t.*
from mytable t )
where rw between 1 and 100000;select v_id,v_name,v_status
from (select rownum rw,t.*
from mytable t )
where rw between 100001 and 200000;
from (select rownum rw,t.*
from mytable t )
where rw between 1 and 100000;select v_id,v_name,v_status
from (select rownum rw,t.*
from mytable t )
where rw between 100001 and 200000;
但不知有没有建好mytable表中以v_id字段的主键和索引表?