Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

ÈçºÎͨ¹ýADOʹÓþۺϺ¯ÊýÀ´²éѯ(Êý¾Ý¿âΪACCESS)

_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
    int ret = 0;
  _RecordsetPtr pset;
CString  sql;
& ......

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

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

Access導³öExecl

VB+Access×öµÄϵ統£¬
為·½±ã²é閱與´òÓ¡£¬
Ðè導³ö為execl±í¸ñ£¬
help¡£
環¾³£ºAccess±íÊÇAccess 2000£»

ÍøÉϺܶà,°Ù¶ÈÒ»ÏÂ

¹Ø×¢£¡

´°Ìå´úÂë
VB ......

VB+AccessµÄÎÊÌ⣬²éѯִÐкó½á¹ûûÓз´À¡~~~~~

        Dim searchKW As String = txtbxSearch.Text
        Dim cmdSearch = New OleDb.OleDbCommand
        cmdSearch.CommandText = " ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ