ACCESS¸üвéѯ - ÆäËû¿ª·¢ÓïÑÔ / Office¿ª·¢/ VBA
ÔõôÑù½«Ò»ÕűíµÄÀïij¸ö×ֶεÄÖµÓÃÁíÒ»ÖµÀ´Ìæ»»?
±ÈÈç:"²úÆ·" Õâ¸ö×Ö¶ÎÀïÓÐ"µçÊÓ»ú","Ï´Ò»ú"µÈ
Òª°ÑµçÊÓ»úµÄֵȫ²¿ÓÃ"´òÓ¡»ú"À´Ìæ»»,ÈçºÎʵÏÖ.
ÈÕÆÚ´Ó:2009-9-1µ½2010-05-1
лл!
ÎÒ¸ãºÃÁË..лл..ÊÇÕâÑùµÄ
Ïà¹ØÎÊ´ð£º
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖظ´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
ÓÃVB³ÌÐòÖн«excelµÄÎļþ·ÅÔں͹¤³Ìͬһ¸öÎļþ¼ÐÖУ¬µ¼ÈëʱûÓдíÎ󣬵«ÔÚ±ðµÄĿ¼Ïµ¼Èë¾Í»á³öÏÖ´íÎó
Ìáʾ£º Ö÷¹Ø¼ü×ÖÖظ´£¨Õâ¸öÅжÏÎÒÔÚ³ÌÐòÖмÓÁË£¬ÔÚºÍACCESSͬһĿ¼ÏÂʱû³öÏÖ´íÎó£©
Common ......
ÒÑÖªAccessÊý¾Ý¿â a.mdb´æÔÚÒ»¸ö±í£ºcc£¬¼ÙÈçccµÄ±í½á¹¹ÈçÏ£º
×Ö¶ÎÃû³Æ Êý¾ÝÀàÐÍ ËµÃ÷
tName Îı¾ Ö¸¶¨ÈËÔ±µÄÐÕÃû
tAge Êý×Ö ......
ÎÒÕâÀïÓÐÒ»¸öscore.mdbµÄaccessÊý¾Ý¿â¡£ÀïÃæÓпγ̡¢ÐÕÃû¡¢Ñ§ºÅ¡¢³É¼¨ËÄÏî¡£ÎÒÏëͨ¹ýVCÁ¬½ÓaccessÊý¾Ý¿â£¬²¢ÔÚVCÖеõ½0-59¡¢60-69¡¢70-79¡¢80-89¡¢90-100Õ⼸¸ö·ÖÊý¶ÎµÄÈËÊýºÍ×ÜÈËÊý¡£ËÄÜ°ïæ¡£±¾È˲ËÄñ¡£Ï£ÍûÏêϸ ......