guaga

¦^´_ 10# joey0415

¯uªº«ÜÁÂÁ§A³o»ò¦³­@¤ßÀ°§Ú!!!

«á¨Ó§Ú¦³°Ñ¦Òºô¯¸¥Îgroup by
SELECT ¾Þ§@­û, sum(²£­È) FROM [¨RÀ£¤é³øªí$] GROUP BY ¾Þ§@­û  ³o­Ó¨S¦³°ÝÃD

¦ý¬O­n¼W¥[¤é´Á¤U¥h ­È´N¶]±¼¤F
SELECT ¾Þ§@­û, sum(²£­È),sum(¤é´Á) FROM [¨RÀ£¤é³øªí$] GROUP BY ¾Þ§@­û

ÁÙ¦³ Äæ¦ìªº¹w³]­È³£¬O³o¼Ë(¦p¹Ï)

¤U¸ü (29.18 KB)

2013-11-13 10:04

joey0415

¦^´_ 11# guaga


    SELECT ¾Þ§@­û, sum(²£­È) as Á`²£­È,sum(¤é´Á) as Á`®É¼Æ FROM [¨RÀ£¤é³øªí$] GROUP BY ¾Þ§@­û

as §â´N§â«e­±ªºªF¦è­«·s©R¦W

joey0415

¦^´_ 11# guaga


±N§Aªº¸ê®Æ²¤Æ¤@¤U¡A¦p¤U

³]©w¤@¤U§Aªº¤é´Á®æ¦¡§Y¥i

select sum([Á`¤u®É(¤À)]) as ®É¼Æ  , ¤é´Á,¾Þ§@­û  from [¤u§@ªí1$] group by ¤é´Á,¾Þ§@­û
   

¤U¸ü (118.13 KB)

2013-11-13 14:43

¤U¸ü (38.84 KB)

2013-11-13 14:43

guaga

¦^´_ 13# joey0415

§A¦n §Ú«á¨Ó¥Î§A»¡ªº¤è¦¡§ï¼g
select
sum([¶}©l®É¶¡]) as ¶}©l®É¶¡  ,
sum([µ²§ô®É¶¡]) as µ²§ô®É¶¡ ,
sum([Á`¤u®É(¤À)]) as Á`¤u®É,
sum([¥ð®§®É¶¡])  as ¥ð®§®É¶¡
sum([À³§¹¦¨®É¶¡(¤À)]) as À³§¹¦¨®É¶¡,
sum([¤u®É®t]) as ¤u®É®t,
sum([²£­È]) as ²£­È ,
¤é´Á,¾Þ§@­û from [¨RÀ£¤é³øªí$]
group by ¤é´Á,¾Þ§@­û

¥i¬O¥ð®§®É¶¡·|¥X¿ù  «á¨Ó§Ú¥ý§â¥ð®§®É¶¡§R±¼

¤U¸ü (98.9 KB)

2013-11-13 15:50

«á¨ÓÅܦ¨¶}©l»Pµ²§ô®É¶¡ ³£¸ò­ì¥»ªº¤£¦P  ¨ì¬O¨ä¥L­È³£¹ï?