- ©«¤l
- 25
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 45
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsXP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- ¨Ó¦Û
- taipei
- µù¥U®É¶¡
- 2013-11-5
- ³Ì«áµn¿ý
- 2024-8-30
|
[µ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¹Ï¤@¼Ë |
|