ÎÊÒ»¸öºÜÈõµÄaccessÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access
дaspÍøÕ¾µÄʱºò£¬ÔÚÍøÉÏÏÂÁ˸öÄ£°å£¬ËûµÄÊý¾Ý¿âÖÐÓÐÒ»¸öid×ֶΣ¬ÔÚaccessÖÐÕâ¸ö×ֶεÄÊÇ×Ô¶¯±àºÅµÄ£¬²»ÄÜÐ޸ģ¬Ìáʾ˵¿Ø¼þÒѰ󶨣¬ÇëÎÊ´ó¸ç¸ç´ó½ã½ãÃÇ£¬ÈçºÎÈ¡ÏûÕâ¸ö°ó¶¨......
ÄãÏëÐ޸ijÉʲô£¿
QQȺ 48866293 / 12035577 / 7440532 / 13666209
ACCESSרҵÂÛ̳
http://www.accessbbs.cn/bbs/index.php .
http://www.office-cn.net/vvb/ .
http://www.accessoft.com/bbs/index.asp .
http://www.access-programmers.co.uk/forums .
.
http://www.office-cn.net/home/space.php?uid=141646 .
¹Ø×¢ÖУ¡£¡
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
ÎÒÁ¬½ÓaccessÊý¾Ý¿â£¬ÒÔǰһֱºÜºÃ£¬×î½üÈ´×ÜÊdzö´í£¨Êý¾Ý¿âÁ¬½Ó³ö´í!£¡£©£¬´úÂëÈçÏ£º
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&" ......