Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¡­¡­

Î


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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

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

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

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

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

·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ