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

Access²éÕÒÖظ´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖظ´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖظ´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬ÈçºÎдÕâ¸öSQL£¬»¹Çë¸ßÈËÖ¸µãһϣ¬Ð»Ð»¡£
½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£

µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

Ìù¼Ç¼¼°ÒªÇó½á¹û³öÀ´¿´¿´
°ÑÖظ´µÄ¹ýÂ˵ô:»¹ÒªÓÐÖظ´µÄ¼Ç¼£¿
try:
select a.* from tt a inner join
(select isbn from tt group by isbn having count(*)=1) b
on a.isbn=b.isbn

[color=#FF0000][/color]
id ÊéÃû ISBN Ŀ¼ ¼ò½é
1 a null ÂÔ ÂÔ
2 b null ÂÔ ÂÔ
3 c 1 ÂÔ ÂÔ
4 c 1 ÂÔ ÂÔ
²»ÏàµÄÊéĿ¼£¬¼ò½é²»Í¬£¬¶øÇÒÏàͬµÄÊéÆäĿ¼ºÍ¼ò½éÒ²²»Í¬£¬µ«ÏàͬµÄÊéÖ»ÐèÏÔʾһÌõ¾Í¿ÉÒÔ£¬²»ÓÃÈ«ÏÔʾ£¬ÈçºÎдSQL£¬Ð»Ð»¡£
 

SQL code:
select ÊéÃû,ISBN,first(Ŀ¼),first(¼ò½é)
from tablename
group by ÊéÃû,ISBN


µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

»¹ÊDz»Ðа¡£¬µ«»¹ÊǵÃллÄú°¡

ÒýÓû¹ÊDz»Ðа¡£¬µ«»¹ÊǵÃллÄú°¡


°Ñ²»ÐеÄÏÖÏó˵³öÀ´£¬·ñÔò±ðÈ˲²»³öÀ´µÄ¡£


Ïà¹ØÎÊ´ð£º

access ²éѯ¼Ç¼µÄÎÊÌâ?

ÎÊÌâÈçÏ£º

ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......

¶¯Ì¬´´½¨accessÊý¾Ý¿âµÄÎÊÌâ2

´´½¨µÄ¹ý³ÌÖгöÏÖdatabase login¶Ô»°¿ò£¬ÇëÎÊÔõôÑù²»ÈøöԻ°¿ò³öÏÖ£¿ÁíÍâÈçºÎ¶¨ÒåÈÕÆÚÐÍÊý¾ÝΪ¶ÌÈÕÆÚÐÍ£¿ºÃÏñÖ»Äܶ¨ÒåΪDatetime¡£

Ô´ÂëÈçÏ£º
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½ ......

ÇóC#¸ßЧ²Ù×÷ACCESSÊý¾Ý¿âµÄ˼·»òÕß´úÂë

´ó¸ÅÇé¿ö£º
C#дµÄwinformÓ¦ÓóÌÐò£¬ÒªÇó³ÌÐòÕûÌìÔËÐС£Êý¾Ý±íºÍÊý¾ÝÁ¿²¢²»´ó£¬±í×î¶à15¸ö£¬ÐÂÔöÊý¾ÝÿÈÕ×î¶à1000Ìõ£¬¶øÇÒ±íÖÐÖ»±£Áôµ±ÌìÊý¾Ý¡£
ÐèҪעÒâµÄÊdzÌÐò¶Ô±íµÄ²éѯºÍÐ޸ķdz£Æµ·±£¬¶øÇÒÊǶà¸öÏß³ÌÍ¬Ê ......

¼Óµ½100·Ö£¬ACCESSÊý¾Ý¿âдÈëÊý¾ÝµÄʱºò´ò¿ªºÜ¿¨£¡

ÎÒдÁ˸ö²É¼¯³ÌÐò£¬Ôڲɼ¯µÄʱºò´ò¿ª²»ÁËÍøÕ¾£¬²É¼¯ÍêÁËÊý¾Ý¿âÊÍ·ÅÁ˲ſÉÒÔ´ò¿ª

ÇëÎÊÈçºÎ×öµ½²É¼¯ºÍä¯ÀÀ²»³åÍ»£¬Ò²¾ÍÊÇ˵²É¼¯Ê±ÍùÊý¾Ý¿âдÊý¾Ýʱ£¬Í¬Ñù¿ÉÒÔÕý³£¶ÁÈ¡Êý¾Ý £¿

ллÄãµÄ½¨Ò飬²»¹ý²»ÊʺÏÎÒÓà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ