ÏÖÔÚÓÐÒ»Õűí
ÄÐ A
ÄÐ D
Å® A
ÄÐ B
ÄÐ A
Å® C
ÄÐ D
Å® A
ÄÐ B
Å® A
ÎÒÏëµÃµ½µÄ½á¹ûÊÇ
A B C D
ÄÐ 2 2 0 2
Å® 3 0 1 0
¸ßÊÖ³öÕУ¡
SQL code:
select cola,
sum ......
ÎÒÔÚ°²×°SQL2005²î²»¶à×îºóµÄʱºòÿ´Î¶¼Ìø³öSQL SERVER 2005°²×°Ê§°Ü Éú³ÉXMLÎĵµÊ±³ö´í£¡£¡£¡
ÕâÊÇÔõô»ØÊ°¡£¬ÓÐËÖªµÀ°¡£¿¸æËßϲ»Ê¤¸Ð¼¤£¡£¡£¡Ê®Íò»ð¼±£¡£¡£¡£¡£¡£¡
²é¿´錯誤ÈÕÖ¾
SQLSERVER2005µÄ°²×°ÅäÖÃÎļþÊÇÉú³ÉÒ»¸öXMLµÄÅäÖÃÎļþ£¬°´ÕÕÕâ¸ö½øÐеġ£
¿´ÏÂÄ㵱ǰÓû§ÊDz»ÊǹÜÀíÔ±Éí·Ý¡£WINDOW ......
ÏÖÔÚÓÐÒ»¸ö±íµÄtable1£¬½á¹¹ÈçÏÂ
ColumnA ColumnB ColumnC ColumnD
a+b+x+c a b x
a/b/c/x±íÊ ......
A±í B±í
WZID WZJG WZID CKID WZSL
ÏÖÔÚÒª²é¶ÔÓ¦µÄÿһ¸öCKIDϵÄ×ܵĽð¶î
¾ÍÊÇÏȲéÿ¸öWUIDÔÚB±íÀïµÄÊýÁ¿£¬È»ºóÓÃWZJG*sum(wzsl)£¬È»ºóÔÙ°´ÕÕÿ¸öCKIDÈ¥sum(WZJG*sum(wzsl))
Ò»Ìõsql£¬Ð»Ð»°¡£¡
Äܲ»ÄÜ˵µÄÃ÷°×µã£¬ÄãµÄWUIDÊÇʲô°¡£¬ÄãµÄB±íÀï ......
1.ÓÐÁ½¸ö±íAAAºÍBBB£¬ÆäÖÐAAA±íÓÐ×Ö¶ÎÉÌÆ·Ãû³ÆmcºÍÉÌÆ·×ÜÁ¿sl,¼Ç¼Èç
SQL code:
mc sl
A 100
B 120
BBB±íÓÐ×Ö¶ÎÉÌÆ·Ãû³ÆmcºÍ³ö¿â×ÜÁ¿sl,¼Ç¼Èç
SQL code:
mc sl
A 10
A 20
B 10
......
Ôõô°ÑÕâÑùÒ»¸ö±í¶ù
year month amount
1991 1 1.1
1991 2 1.2
1991 3 1.3
1991 4 1.4
1992 1 2.1
1992 2 2.2
1992 3 2.3
1992& ......