accessÖÐdistinctµÄÓ÷¨
ÎÒÓõÄaccess2003£¬±íÊý¾ÝÈçÏ£º col1 col2 zhao 22 zhang 33 zhao 14 zhao 12 Ï£Íû¶ÁÈ¡col1²»Öظ´µÄËùÓÐ×ֶΣ¬¶øÇÒÖ»¶Á²»Öظ´µÄcol1µÄËùÓмǼµÄµÚÒ»Ìõ£¬°´ÕÕcol2ÅÅÐò£¬sqlÓï¾ä¸ÃÔõôд£¿ ½á¹ûÓ¦¸ÃÊÇ£º col1 col2 zhang 33 zhao 12
ÒýÓà ²Î¿¼ Èç¹ûÊÇÀàËÆÏÂÃæµÄ²éѯÓï¾ä,¾ÍûÎÊÌâ: select distinct ×Ö¶Î from ±í Èç¹ûÊÇÓÃÔھۺϺ¯ÊýÖÐ,¾Í²»Ö§³Ö. select count(distinct ×Ö¶Î) from ±í Ò²¿ÉÒÔתÍäÒ»ÏÂд¸ö¼æÈÝmssqlºÍaccess µÄ´úÂë select count(*) from T group by ×Ö¶Î select col1 from tab group by col1 select count(*) as tab from (select distinct a from tab ) ÒÔÉÏÎÒûÊԳɹ¦£¬Çë×¢Ò⣬Èç¹ûÓÐ3Ìõ¼Ç¼µÄcol1ÊÇÖØ¸´µÄ£¬ÄÇôֻ¶ÁȡһÌõ¼Ç¼ ÕâÀïÃæÃ»ÓÐÉæ¼°µ½ÇóºÍ£¬Ö»ÊǶÁ³öÀ´²»Öظ´Ä³×ֶεÄËùÓмǼ£¬µ±È»¸Ã¼Ç¼Ҫ°üÀ¨ËùÓÐ×Ö¶Î
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿ <%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬ http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
ÎÊÌ⣱ ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´ ¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í ¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´... ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
´ó¼Ò°ïÏÂæÁË Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ ±ÈÈçÎÒÏÖÔÚ²éѯ SELECT * from XS WHERE רҵÃû='¼ÆËã»ú' ²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿ ±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......