- ©«¤l
- 6
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 7
- ÂI¦W
- 0
- §@·~¨t²Î
- window
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-8-22
- ³Ì«áµn¿ý
- 2014-9-22
|
access¬d¸ß
³]¥ß¤@Ó¬d¸ß ¡Asql¦p¤U¡G
SELECT [¶^ˤG¦¸¥H¤W¤H¼Æ ¬d¸ß].¤ë¥÷, Count([¶^ˤG¦¸¥H¤W¤H¼Æ ¬d¸ß].¯f¾ú¸¹½X) AS ¯f¾ú¸¹½X¤§µ§¼Æ1
FROM [¶^ˤG¦¸¥H¤W¤H¼Æ ¬d¸ß]
GROUP BY [¶^ˤG¦¸¥H¤W¤H¼Æ ¬d¸ß].¤ë¥÷;
·Q½Ð°Ý¤@¤U¦pªG·Qn´Nºâ¬Y¤ë¨S¦³µo¥ÍÂÜˤG¦¸¥H¤Wªº¤H¼Æ
¤]·Qn¦b¬d¸ß¸Ì¬O¥i¥H¥X²{¤ë¥÷
¦~ ¤ë µ§¼Æ
10301 0
10302 2
10303 6
¬O§_¦³¿ìªk¥i¥H¿ì¨ì©O¡HÁÂÁ |
|