accessÀïµÄÊÓͼ£¬ÐèÒª+Ë÷Òýô - Web ¿ª·¢ / ASP
ÈçÌ⣬Ôõô+£¿
²»ÐèÒªÔÙÔÚÊÓͼ¼ÓË÷ÒýµÄ¡£ ËùνÊÓͼË÷ÒýÒ»°ãÓÃÓÚͳ¼Æ.
ÄÇÊÓͼ»á²»»áºÜÂý
Ò²¾ÍÊÇ˵£¬ÊÓͼ×îºÃÄÜ´øÉÏÔÀ´±íµÄID×ֶΣ¿£¨×Ô¶¯Ë÷Òý£©¶Ôô¡£ÄÇÎÒÃ÷°×ÁË
accessÓÐÊÓͼÂð
Ïà¹ØÎÊ´ð£º
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
ÏÂÃæÊÇÊý¾Ý
ID Money PID
1 50
2 40 1
3 30 1
4 ......
ÎÒÁ¬½ÓaccessÊý¾Ý¿â£¬ÒÔǰһֱºÜºÃ£¬×î½üÈ´×ÜÊdzö´í£¨Êý¾Ý¿âÁ¬½Ó³ö´í!£¡£©£¬´úÂëÈçÏ£º
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&" ......