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Êý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ ±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð» ÄãÔõôÁ¬µÄ£¿ AccesÊý¾Ý¿â.. ÄãÔõôÁ·µÄÄØ£¿ Java code: static String DBDRIVER = "sun.jd ......
ÇëÎÊÓÐÈËÖªµÀÈçºÎÔÚkernel mode ÏÂд64 bit driver, ¿ÉÒÔ½«IO bitmap ´ò¿ª£¬ 32bit¿ÉÒÔÓÃKe386SetIoAccessMapºÍKe386IoSetAccessProcess£¬ Çë問64 bit driverÓÐÀàËÆµÄfunctionaÂð? ûŪ¹ý¡£ GoogleµÄ£ºhtt ......
ÎÒÏë±£Áô±íÖÐ×îеÄ30¸öÊý¾Ý£¨ÓмǼʱ¼äµÄ×Ö¶Îaddtime£©£¬ÆäÓàµÄɾ³ý£¬ÇëÎÊsqlÓï¾äÔõÑùÐ´ÄØ£¿Ð»Ð»¡£ End_rbody_64466527//--> ¸Ã»Ø¸´ÓÚ2010-04-27 08:37:30±»°æÖ÷ɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[ ......
oracle ´úÂ룺 select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2 Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......