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
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
ÇëÎʸ÷λ¸ç¸ç½ã½ã£¬ÈçºÎÔËÓÃÏֳɵÄÄ£°åÀ´ÖÆ×÷ƯÁÁµÄJSPÍøÒ³Ñ½,»ØÕßÓзÖ!
×Ô¼º¶¥Ï£¬×ÜÓиßÊÖ°É,ÆÚ´ýÖÐ......
Èç¹ûÖ±½ÓÒýÓýøÈ¥
¿ÉÒÔÖ±½ÓÓÃjspµÄÖ¸ÁҲ¿ÉÒÔÓÃfreemarkÒýÓ㬼ǵøø·Ö
лл¸÷λÁË£¬¿´À´Î ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......