oracle²éѯ²¢È¡³öij¸ö·¶Î§ÐÐÎÊÌâ - Oracle / ¿ª·¢

²éѯ³öѧϰ³É¼¨¼°¸ñµÄËùÓÐѧÉú
²¢È¡³öµÚ10ÖÁ20Ãû

±í¿ÉÒÔ×Ô¼ºÆðÃû×Ö,ֻҪʵÏÖ¾ÍÐÐ

---

select * from 
(select t.*,rownum flag from table t order by ³É¼¨ desc )
where flag >= 10 and flag <= '20'

---

rownum > ij¸öÊý×Ö OR rownum = ·Ç1µÄÊý×Ö
¶¼ÊDz»ºÏ·¨µÄ°É

---

select * from (
select b.* ,rownum as rn from 
(select t.* from table t where ³É¼¨>=60 order by ³É¼¨ desc )b)
where rn<=20 and rn>=10

---

Ç°Ìá:¼°¸ñµÄÐÐÊýÒª³¬¹ý20ÐÐ
SQL code:
select * from (select rownum rn,³É¼¨ from ±íÃû where ³É¼¨ >= 60 order by ³É¼¨ desc)
where rn >= 10 and rn <= 20

---

ÒýÓÃ

²éѯ³öѧϰ³É¼¨¼°¸ñµÄËùÓÐѧÉú
²¢È¡³öµÚ10ÖÁ20Ãû

±í¿ÉÒÔ×Ô¼ºÆðÃû×Ö,ֻҪʵÏÖ¾ÍÐÐ

SQL code:

select *
from (select rownum rn,a.* from tb a
where a.cj>=60
order by cj desc)
where rn>=10 and rn<=20

---

¶àл!¸Ï½ô½áÌù,Òª²»·Ö¶¼²»¹»·ÖÁË