tb_a ±í ÓУº
mobile varchar(20),
fee money£¬
.......
tb_b±í ÓУº
mobile varchar(20),
fee money£¬
ʵÏÖ£¬tb_a ÖÐÈç¹û mobile ÔÚtb_b±íÖУ¬ÔòÐÞ¸ÄfeeֵΪtb_b±íÖжÔÓÚfeeµÄÖµ
ɶÒâ˼???
»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡&n ......
±í:
group value
1 1
1 2
1 3
2 1
2 3
3 1
3 3
ÿһ×éÖÐ(id)ȡһ¸öÖµ, ......
ÈçÌ⣬¹À¼Æ¿ÉÄÜÊDz¡¶¾º¦µÄ£¬³ýÁËɱ¶¾£¬»¹ÓÐʲôºÃµÄ½â¾ö°ì·¨£¿
´ò¿ªÁË£¬ÓÃÃû³Æ¿ÉÒÔ×¢²á¡£
´ÓÄã±¾»útelnetÔ¶³ÌµÄÊý¾Ý¿â¶Ë¿Ú ͨÂð£¿
ÔÚHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectToϽ¨Á¢Á½¸ö×Ö·û´®Öµ£º
1¡¢ÊýÖµÃû³Æ£ºipµØÖ·£¨Óû§×ÔÐÐÐ޸ģ¬ÎÞÐè¶Ë¿ÚºÅ£©
  ......
¼ÙÉèÓÐÕâÑùÒ»Õűí
create table test_db (
id number,
name varchar2(10),
count number,
logdate date
)
¼ÙÉèÓÐÕâЩ¸öÊý¾Ý:
1,a1,1,2010-02-03
2,a2,2,2010-02-03
.................
10,a10,10,2010-02-03
11,a11,11,2010-02-03
..............
30,a3, ......
Óô¿C#дһ¸öѧÉú¹ÜÀíϵͳ¡¡
½øÐÐÔöɾ¸Ä²é²¢ÇÒ¿ÉÒÔ±£´æ¡¡
²¢ÇÒÍ˳öºóÏ´λ¹ÓÐÉÏ´ÎÐ޸ĵÄÀàÈÝ
ÄǸö¡¡ÊÇÔõô×öµ½µÄ¡¡
ÊÇдÈçÎı¾È»ºó¶ÁÈ¡
»¹ÊÇÆäËüµÄ·½·¨?
¿É²»¿ÉÒÔ Ð½¨Ò»¸ö ѧÉú Àà
È»ºóÔÚ Ð´Ò»Ð© ×Ö¶Î ±ÈÈç ÐÕÃû ÄêÁä µç»° µÈ
È»ºóÔÚ½øÐÐÐÞ¸Ä ¿ÉÊÇÔõôÑù ÄÜʵÏÖÍ˳öºó±£´æÄØ
»¹ÓÐ ÎÒÏë°ÑËüµÄ½çÃæ × ......
ÎÒÓÐÒ»¸öÊý¾Ý¿â£¬ÀïÃæÓкöà±í£¬¶øÇÒ±íÀïÃæ¶¼ÊÇÓÐ×Ô¶¯Ôö³¤µÄIDÁУ¬ÏÖÔÚÎÒÏë°ÑÀïÃæµÄÊý¾Ý¶¼Çå¿Õ£¬È»ºóÈÃID´Ó1¿ªÊ¼¼ÆË㣨¾ÍÊÇÎÒÖØÐÂÔÙ²åÈëÊý¾Ýʱ£¬ID´Ó1¿ªÊ¼¼ÆË㣩£¬ÓÐʲô·½·¨Ã´£¿¼±£¡£¡
ÕâÑù¾ÍÒªÒÔ´Ó¿ªÊ¼¼ÆËãÁËô£¿Êý¾Ý¿â±¾ÉíÔÀ´µÄ´¥·¢Æ÷£¬´æ´¢¹ý³Ì»¹ÓÐЧÊÇô£¿
ÒýÓÃ
ÕâÑù¾ÍÒªÒÔ´Ó¿ªÊ¼¼ÆËãÁËô£¿Êý¾Ý¿â±¾ÉíÔÀ´µÄ´¥ ......