Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ