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

ACCESSʱ¼ä²éѯ£¬ÅжÏÎÊÌ⣬ÔÚÏßµÈ

Çë½Ì£º
  ±íA½á¹¹ÈçÏ£ºID StartTime EndTime
  1 2010/4/2 9:00:00 2010/4/2 11:00:00
  2 2010/4/2 12:00:00 2010/4/2 14:00:00
  . ... ...

  ÏÖÎÒÓµÓÐÁ½¸öʱ¼ä±äÁ¿a,b£¬ÔõÑù²éѯ¿ÉÒÔµÃÖªa,bËù×é³ÉµÄʱ¼ä¶ÎºÍ±íÖÐStartTime£¬EndTime¹¹³ÉµÄʱ¼ä¶Î²»³åÍ»£¿
  ÎÒÏëµ½µÄÊÇÕâÑù£º
  1.ÌÈÈôaСÓÚStartTimeÖÐ×îС£¬ÄÇôbÒ²Ó¦¸ÃСÓÚStartTimeÖÐ×îСµÄ¼Ç¼£¬Í¬Ê±bÓ¦¸Ã´óÓÚa£»
  2.ÌÈÈôa´óÓÚEndTimeÖÐ×î´ó£¬ÄÇôbÒ²Ó¦¸Ã´óÓÚEndTimeÖÐ×î´ó£¬Í¬Ê±bÓ¦¸Ã´óÓÚa£»
  3.ÌÈÈôa²»±ÈStartTimeÖÐ×îСµÄС£¬Ò²²»±ÈEndTimeÖÐ×î´óµÄ´ó£¬ÄÇôa²»Ó¦¸Ã´¦ÓÚÓÉStartTimeºÍEndTimeËù×é³ÉµÄÈÎÒâʱ¼ä¶ÎÄÚ£¨Õâ¸öÎÒ¿ÉÒÔͨ¹ýbetweenÅжϣ©£¬ÕâÖÖÇé¿öÏÂÎÒÓ¦¸ÃÔõÑù¶Ôb×öÅжÏÄØ£¿ÎÒµÄ˼·ÊDzé³öÀëa×î½üµÄStartTime£¬È»ºóbÓ¦¸ÃСÓÚ´ËStartTime£¬µ«¿É±¯µÄÊÇÎÒ²»ÖªµÀÔõÑùµÃµ½Àëa×î½üµÄStartTime£¨ÎÒ²»ÄÜÿ¸ö¶¼Ïë¼õÈ¡×îСֵ°É£¿£©£¬²»ÖªµÀACCESSÓÐûÌṩʲôʱ¼ä·½ÃæµÄº¯Êý¿É¹©µ÷Óã¬Çë¸øÓè°ïÖú¡£

¼ÅįµÄSF

û¿´¶®£¬½¨ÒéÄÜÓÃʵ¼ÊÀý×Ó˵Ã÷¡£

  ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
  ²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓµÄÌáÎÊ·½Ê½http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html



¾ÍÊǶ©»áÒéÊÒ£¬¿ªÊ¼Ê±¼äºÍ½áÊøÊ±¼ä²»ÄܺÍÒÑ´æÔÚµÄʱ¼ä¶Î³åÍ»£¬Ó¦¸ÃÔõôÅжϷ½±ã

ÈýÂ¥ÒѾ­¸ø³ö´ð°¸ÁË¡£

ÒýÓÃ
ÈýÂ¥ÒѾ­¸ø³ö´ð°¸ÁË¡£

Ã²ËÆÕâÑù²»ÐаÉ<


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

linux²»ÄÜ·ÃÎÊaccess - Java / Java EE

rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬Ë­ÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿

AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿

Java code:

static String DBDRIVER = "sun.jd ......

64 bitÈçºÎдDriverÈ¥Access IO - VC/MFC / Ó²¼þ/ϵͳ

ÇëÎÊÓÐÈËÖªµÀÈçºÎÔÚkernel mode ÏÂд64 bit driver, ¿ÉÒÔ½«IO bitmap ´ò¿ª£¬
32bit¿ÉÒÔÓÃKe386SetIoAccessMapºÍKe386IoSetAccessProcess£¬
Çë問64 bit driverÓÐÀàËÆµÄfunctionaÂð?
ûŪ¹ý¡£
GoogleµÄ£ºhtt ......

Ò»¸öaccessÊý¾Ý¿âÎÊÌâ¡£ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÏë±£Áô±íÖÐ×îеÄ30¸öÊý¾Ý£¨ÓмǼʱ¼äµÄ×Ö¶Îaddtime£©£¬ÆäÓàµÄɾ³ý£¬ÇëÎÊsqlÓï¾äÔõÑùÐ´ÄØ£¿Ð»Ð»¡£


End_rbody_64466527//-->
¸Ã»Ø¸´ÓÚ2010-04-27 08:37:30±»°æÖ÷ɾ³ý


¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[ ......

ACCESSÈ¥³ýÖØ¸´Öµ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ