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

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ÊÇÖØ¸´µÄ£¬ÄÇôֻ¶ÁȡһÌõ¼Ç¼

ÕâÀïÃæÃ»ÓÐÉæ¼°µ½ÇóºÍ£¬Ö»ÊǶÁ³öÀ´²»Öظ´Ä³×ֶεÄËùÓмǼ£¬µ±È»¸Ã¼Ç¼Ҫ°üÀ¨ËùÓÐ×Ö¶Î


Ïà¹ØÎÊ´ð£º

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

ÈçºÎ½«accessÀïÃæµÄ¸½¼þ±£´æµ½´ÅÅÌÉÏÄØ

Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit

ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......

VCÁ¬½ÓACCESSÊý¾Ý¿âÎÊÌâ - VC/MFC / Êý¾Ý¿â

ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í 
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......

¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP

ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......

VC ADO ACCESS sql ²éѯ - VC/MFC / Êý¾Ý¿â

´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ