oracle·ÖÒ³¾ÍÓÃÕâÒ»¾ä
·ÖÒ³µÄ×ÚÖ¼ÊÇ¿ØÖƲéѯ³öÀ´µÄÊý¾Ý¸öÊý£¬ÏÂÃæÕâÌõÓï¾ä¶ÔÓÚOracle·ÖÒ³ÒѾ×ã¹»ÁË¡£
£¨×¢£º¸ÃÓï¾äÖ»ÄÜÓÃÓÚOracle£©
SELECT * from (SELECT temp.*, ROWNUM RN from (SELECT * from USERS ORDER BY ID DESC) temp) WHERE RN > 0 AND RN <= 10
SELECT *
from (SELECT AA.*, ROWNUM RN
from (SELECT * from USERS ORDER BY ID DESC) AA)
WHERE RN > 0 AND RN <= 10
˵Ã÷£º
ÆäÖÐUSERSΪÊý¾Ý¿â±íÃû
SELECT * from USERS ORDER BY ID DESC
ÕâÒ»¾äÊDz»½øÐзÖÒ³µÄ²éѯ¡£
¶øROWNUM <= 10ºÍRN >0ÓÃÓÚ¿ØÖÆÿҳҪÏÔʾµÄÊý¾ÝÌõÊý£¬ÎÒÕâÀïÓÃROWNUM <= 10ºÍRN >0±íʾÿҳÏÔʾ10ÌõÊý¾Ý£¬ÄÇôҪ½øÈëÏÂÒ»Ò³£¬ÔòROWNUM <= 20ºÍRN >10
ÉÏÃæµÄÕâÁ½¸öÊýÖµÖ»ÐèÒªÄãÔÚ³ÌÐòÖж¯Ì¬´«ÈëÖµ£¬ÀýÈçÔÚstruts»òservletÖж¯Ì¬´«ÈëÁ½¸ö²ÎÊý¾Í¿ÉÒÔ½øÐзÖÒ³¿ØÖÆ¡£
MSSQL SYBASEÏÂÃæÓÃtop À´·ÖÒ³
POSTGRESQL MYSQL¾ÍÖ±½ÓÓÃlimit¸ü¼òµ¥ÁË
ÔÚoracle ÏÂÃæÓÐ4ÖÖ·½·¨
oracle·ÖÒ³¼¼Êõ2007Äê08ÔÂ13ÈÕ ÐÇÆÚÒ» 23:08Á½ÖÖ·ÖÒ³¼¼Êõ£¬µÚ¶þÖÖЧÂʸ߶àÁË
1. select * from
(select rownum rn,t.* from table t )
where rn <50 and rn>=1
2. select * from
(select rownum rn,t.* from table t rownum<50)
where rn>=1
´øÅÅÐòÒªÇóµÄ·ÖÒ³£¬ÔÚ9iÒÔÉϵĻ·¾³ÍƼöʹÓ÷ÖÎöº¯Êý
select * from
(select row_number() over(order by esn) rn,esn,akey from as_esn_info )
where rn <50 and rn>=1
£¨ÒÔÉÏ·½·¨ÑéÖ¤¹ý£©
»òÕßÒÔÏÂ
£¨1£©minus²î·ÖÒ³ £ºselect * from table where rownum<=10 minus select * from table where rownum<=5
£¨2£©rownumαÁзÖÒ³ £ºselect * from (select rownum tid,t.* from table t where rownum<=10) where tid>5
£¨3£©notinÏà·´·ÖÒ³£ºselect * from table where id not in(select id from table where rownum<=5) and rownum<=5
Ïà¹ØÎĵµ£º
SDO_FILTER
¸ñʽ£º
SDO_FILTER(geometry1, geometry2, params);
ÃèÊö£º
ͨ¹ý¿Õ¼äË÷Òý£¬¸ù¾Ý¸ø¶¨µÄ¼¸ºÎÒªËؼìË÷³ö¾ßÓпռäÏ໥¹ØϵµÄ¿Õ¼ä¶ÔÏó¡£ÕâÀïµÄ¿Õ¼ä¹ØϵÊÇÖ¸Á½¸ö¼¸ºÎ²»·ÖÀ룬¼´Non-disjoint¡£¡¾disjoint£º±íʾÁ½¸ö¼¸ºÎµÄ±ßºÍÄÚ²¿¶¼²»Ïཻ¡¿
Õâ¸öSdo_Fi ......
TO_DATE¸ñʽ
Day:
dd number 12
dy abbreviated fri
day spelled out friday
ddspth spelled out, ordinal twelfth
Month:
mm number 03
mon abbreviated mar
month spelled out march
Year:
yy two digits 98
yyyy four digits 1998
24Сʱ¸ñʽÏÂʱ¼ä·¶Î§Îª£º 0:00:00 - 23:59:59....
12Сʱ¸ ......
oracleÊý¾Ý¿âÖÐÐÞ¸ÄÊý¾ÝʱÌáʾ“¼Ç¼±»ÁíÒ»¸öÓû§Ëøס” ½â¾ö·½·¨£º
1>²é¿´Êý¾Ý¿âËø,Õï¶ÏËøµÄÀ´Ô´¼°ÀàÐÍ£º
¡¡¡¡select object_id,session_id,locked_mode from v$locked_object;
»òÕßÓÃÒÔÏÂÃüÁ
select b.owner,b.object_name,l.ses ......