Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÊÇÖØ¸´µÄ£¬ÄÇôֻ¶ÁȡһÌõ¼Ç¼

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


Ïà¹ØÎÊ´ð£º

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

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

Vb.net Access CrystalReport - .NET¼¼Êõ / VB.NET

µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......

ÈçºÎÐÞ¸ÄACCESSϵͳ±í

ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É

²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£

ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...

лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......

²éѯACCESSÖзûºÏÌõ¼þ¼Ç¼µÄÓï·¨¸ñʽ

ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......

ACCESSµÈ¿âʵÏÖÖðÈÕͳ¼Æ - MS-SQL Server / »ù´¡Àà

±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä  
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ