select t.* from (select rownum nn,* from t_student order by student_id) t where t.nn>=50 and t.nn<=100 order by t.student_id
select * from (select row_number() over(order by a.student_id) as num,a.* from t_student a ) c where c.num between 50 and 100 或者 select * from (select rownum as num,a.* from t_student a order by a.student_id) c where c.num between 50 and 100
select * from (select row_number() over(order by a.student_id) as num,a.* from t_student a ) c where c.num>=50 and c.num<=100
select top 100 * from t_student where student_id not in (select top 49 student_id from t_student order by student_id ) order by student_id
select row1,row2,row3,row4 from ( select rownum as seq,row1,row2,row3,row4 from t_student where rownum < 101 order by student_id ) where seq > 49
select * from t_student where rownum < 50 order by student_id minus select * from t_student where rownum < 100 order by student_id
哦应该是 select * from t_student where rownum < 100 order by student_id minus select * from t_student where rownum < 50 order by student_id
(select rownum nn,* from t_student order by student_id) t
where t.nn>=50 and t.nn<=100
order by t.student_id
(select row_number() over(order by a.student_id) as num,a.*
from t_student a
) c
where c.num between 50 and 100
或者
select * from
(select rownum as num,a.*
from t_student a
order by a.student_id) c
where c.num between 50 and 100
(select row_number() over(order by a.student_id) as num,a.*
from t_student a
) c
where c.num>=50 and c.num<=100
) order by student_id
(
select rownum as seq,row1,row2,row3,row4 from t_student where rownum < 101 order by student_id
)
where seq > 49
minus
select * from t_student where rownum < 100 order by student_id
select * from t_student where rownum < 100 order by student_id
minus
select * from t_student where rownum < 50 order by student_id
根据你需要的排序规则,在写相应的SQL语句。
谁说不可以,套一层不就可以用了.zxwl(魔君七夜)
你是先取记录后排序的,不信你可以试试你的语句!