Oracle ¸ßÊÖ½ø - Java / Java EE

SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21

SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE RN >= 21

ͬÑùʵÏÖ·ÖÒ³,ÏÖÔÚ¹«Ë¾ÓõÄÊÇÉÏÃæµÄ,ÍøÉÏҲ˵ÉÏÃæµÄ.ÏÂÃæÕâ¸öÉÙÒ»¸öselect ,ËüÃÇÓÐʲôÇø±ðÂð?

---

µÚ¶þ¾ä£¬Èç¹ûÓиö ORDER BY ¾Í²»ÕýÈ·ÁË¡£

SQL code:
SELECT k.*
from (SELECT a.*, rownum rn
from g_test_a a
ORDER BY a.id DESC) k
WHERE k.rn > 5 AND k.rn < 11;

SELECT k.*
from (SELECT a.*, row_number() OVER(ORDER BY a.id DESC) rn
from g_test_a a) k
WHERE k.rn > 5 AND k.rn < 11;

---

ÕâÒ»ÖÖ·ÖÒ³µÄÓŵãÔÚ?

---

SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30 order by user_loginname)WHERE RN >= 21

SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30 order by user_loginname) A WHERE RN >= 21

ÕâÑùÒ²¿ÉÒÔ°¡

---

Èç¹ûÄÜÐеĻ°£¬¾ÍÓðɡ£ÌõÌõµÀ·ͨÂÞÂí£¬ºÇºÇ¡£

---

ÎÒû¿´³öɶÇø±ð
¶¼ÄܴﵽĿµÄ¾ÍÐÐ
ЧÂÊÓ¦¸ÃҲûʲô´óµÄ²î¾à°É

---

ÎÒÏë Ö÷ÒªÊÇ¿¼ÂÇ ¹«ÓÃÐÔ°É~~ 1ÖÐ ÔÚ ×îÀï²ãµÄ ¿ÉÒÔ¼Ó²éѯÌõ¼þ
¶ÔÈÎÒâselect Ö»ÒªÔÚÍâÃæ°üÉÏ ¿Ç×ӾͿÉÒÔ·ÖÒ³ÁË

---

µ±È»ÓÐÇø±ð Â¥Ö÷
Õâʱһ¸öЧÂʵÄÎÊÌâ,¿ÉÒÔ¿´µ½ÔÚµÚÒ»ÌõsqlÖÐ
(SELECT A.*, ROWNUM RN from (SELECT * from t_o