ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ·Q½Ð°Ý³o¬q»yªk¦³­þ¸Ì¥X¿ù¶Ü

[µo°Ý] ·Q½Ð°Ý³o¬q»yªk¦³­þ¸Ì¥X¿ù¶Ü

·Q½Ð°Ý¤j®a
¯àÀ°§Ú¬Ý¤@¤U ³o¬q»yªk¦³­þ¸Ì¥X¿ù¶Ü

select sum([¶}©l®É¶¡]) as ¶}©l®É¶¡ ,
sum([µ²§ô®É¶¡]) as µ²§ô®É¶¡ ,
sum([Á`¤u®É(¤À)]) as Á`¤u®É ,
sum([À³§¹¦¨®É¶¡(¤À)]) as À³§¹¦¨®É¶¡ ,
sum([¤u®É®t]) as ¤u®É®t ,
sum([²£­È]) as ²£­È , ¤é´Á ,¾Þ§@­ûfrom [¨RÀ£¤é³øªí$]
group by ¤é´Á,¾Þ§@­û

­pºâ§¹¦¨«á ©Ò¦³ªº­È³£¹ï,¦ý¬O ¶}©l®É¶¡»Pµ²§ô®É¶¡«o¤£¹ï

¶}©l»Pµ²§ô®É¶¡ À³¸Ó­n¸ò¤U­±¨º±i¹Ï¤@¼Ë

¦^´_ 1# guaga


    group by ¤é´Á,¾Þ§@­û

    group by

¬O±N¸ê®Æ¤À¸s¡A°µ¥[Á`©Î¥­§¡... ¡A¥­±`ªº¶}©l©Îµ²§ô®É¶¡¤£¯à¥Îgroup by

³q±`¬O¤ë©Î¶g¸ê®Æ¤~·|group by

¥­±`³æ¤é³£¥u¥Î

¨Ò¦p¡G  where  ¤é´Á='20131115'ªº«ü©w¤è¦¡¡A¦pªGÁÙ­n¥[¤W¬Y¨Ç¯S®í¸ê®Æ¡A§A¥i¯à­n¬d¸ß¤@¤U  join ªº»yªk

TOP

¦^´_ 2# joey0415


¥»¨Ó·Q»¡ ©ñ¦bVBA¨ºÃä ¤w¸g¸ò¥DÃDµLÃö¤F ©Ò¥H²¾¨ì³oÃä
ÁÂÁ§A §Ú·|¦A¥J²Ó¬ã¨sªº:)

TOP

¥Îgroup by ¬O¦]¬°¨Ï¥Î»E¦X¨ç¼Æ ¤@©w­n¨Ï¥Î¡AÀ³¸Ó¨S¿ù³á ¥u¬O ¶}©l®É¶¡¸òµ²§ô®É±µ ¥ÎSUM»Pªk´N©Ç©Çªº¡ASUM¤£¤Ó¥i¯à¥h¥[Á`"¶}©l""µ²§ô"®É¶¡¡A¦]¬°¨S¦³§¹¥þ¸ê®Æªí¡A¤]¬Ý¤£¥X°ÝÃD¡A«Øij ¶}©l µ²§ô¨ºªºSUM§ï¤@¤U

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD