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 ¾ÍÊǶ©»áÒéÊÒ£¬¿ªÊ¼Ê±¼äºÍ½áÊøÊ±¼ä²»ÄܺÍÒÑ´æÔÚµÄʱ¼ä¶Î³åÍ»£¬Ó¦¸ÃÔõôÅжϷ½±ã ÈýÂ¥ÒѾ¸ø³ö´ð°¸ÁË¡£ÒýÓà ÈýÂ¥ÒѾ¸ø³ö´ð°¸ÁË¡£ Ã²ËÆÕâÑù²»ÐаÉ<
Ïà¹ØÎÊ´ð£º
µÚÒ»´Î½Ó´¥CrystalReport ¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó. ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл! ¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺ ×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏ HTTP Status 500 - ------------------------------------------------------------------------------- ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡ ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡ ¸ù¾ÝÕâ¸ö¸Ä°É C# code: public static Product[] SearchProducts(string keyword, int categoryID, int pa ......
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£ Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......
oracle ´úÂ룺 select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2 Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......