Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ......

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

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

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

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

dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌâ

ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:

public static Product[] SearchProducts(string keyword, int categoryID, int pa ......

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ºÅ