Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚoracle rownumµÄÒ»¸ösqlÓï¾ä¡£¡£ - Oracle / ¿ª·¢

¿´ÏÂÃæsqlÓï¾ä£¬ÎÒÏëÓà rw À´ÊµÏÖ´Ón-mµÄ½ØÈ¡
select * from(select times,pages,rownum rw from layouts) where times='20090105' order by pages asc;

½á¹ûÊÇ£º
 times pages rw
20090105 A001 96
20090105 A002 97
20090105 A003 98
.
.

Ϊʲôrw²»ÊÇ´Ó1¿ªÊ¼µÄ£¿ÒÔÖÁÓÚÎÒÔÚwhereºóÃæÓà rw>=10 and rw<=20µÄʱºòûÓÐÖµ¡£¡£¡£
½âÎö:
1¡¢¡°ÎªÊ²Ã´rw²»ÊÇ´Ó1¿ªÊ¼µÄ£¿¡±
select times,pages,rownum rw from layouts
³öÀ´µÄ½á¹û¼¯Ò»¶¨ÊÇ
 times pages rw
XXXXXXXX XXXX 1
XXXXXXXX XXXX 2
XXXXXXXX XXXX 3
...
20090105 A001 96
20090105 A002 97
20090105 A003 98
...

È»ºóÄãÔÙtimes='20090105',½á¹û¼¯ÀïÃærwµ±È»Ö»ÓÐÊÇÂú×ãÌõ¼þµÄ½á¹ûÁË¡£

2¡¢¡°ÒÔÖÁÓÚÎÒÔÚwhereºóÃæÓà rw>=10 and rw<=20µÄʱºòûÓÐÖµ¡±
Õâ¸öÐÞ¸Äһϣ¬½«times='20090105'·Åµ½×Ó²éѯÖоͿÉÒÔÁË¡£
select * from(select times,pages,rownum rw from layouts where times='20090105') 

Ï£Íû¶ÔÄãÓÐËù°ïÖú

ÒòΪÕâÀï°´pagesÅÅÐòÁË£¬ËùÒÔrw²¢²»ÊÇ´Ó1¿ªÊ¼£¬rownumÊÇÔÚorderby֮ǰ¸³ÓèµÄαÁÐ

ÎÒÒ²¸ã²»ÇåÂ¥Ö÷×´¿ö£¬ ÊÇÏñÂ¥ÉÏ1¡¢Àï˵µÄÂð£¿

ÒýÓÃ

½âÎö:
1¡¢¡°ÎªÊ²Ã´rw²»ÊÇ´Ó1¿ªÊ¼µÄ£¿¡±
select times,pages,rownum rw from layouts
³öÀ´µÄ½á¹û¼¯Ò»¶¨ÊÇ
times pages rw
XXXXXXXX XXXX 1
XXXXXXXX XXXX 2
XXXXXXXX XXXX 3
...
20090105 A001 96
20090105 A002 97
20090105 A00¡­¡­

Î


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ