¾ðÊó²Ê³Ø¤ò³Ø¤ÖÂç³ØÀ¸¤Î¥Ö¥í¥°

¾åµ­¤Î¹­¹ð¤Ï£±¥ö·î°Ê¾å¹¹¿·¤Î¤Ê¤¤¥Ö¥í¥°¤Ëɽ¼¨¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
¿·¤·¤¤µ­»ö¤ò½ñ¤¯»ö¤Ç¹­¹ð¤¬¾Ã¤»¤Þ¤¹¡£

¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯

¹ÖµÁ»ñÎÁ¤Ë¤¢¤Ã¤¿

SELECT COUNT(DISTINCT °À­2)
  FROM ¥Æ¡¼¥Ö¥ë1

¤È¤¤¤¦SQLʸ¤òMicrosoft Access 2003¤ËÆþÎϤ·¤¿¤È¤³¤í¡¢

¥¯¥¨¥ê¼° 'COUNT(DISTINCT °À­2)' ¤Î ¹½Ê¸¥¨¥é¡¼ : ±é»»»Ò¤¬¤¢¤ê¤Þ¤»¤ó¡£

¤È¤¤¤¦¥¨¥é¡¼¤¬È¯À¸¤·¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£

¥Æ¡¼¥Ö¥ë1

°À­1	°À­2
AA	¡û¡û
BB	¢¤¢¤
CC	¢¢¢¢
DD	¡û¡û

¤³¤Î¤è¤¦¤Ë½¸Ìó±é»»¤ò¹Ô¤¦´Ø¿ô¡ÊAVG(), COUNT(), SUM()¤Ê¤É¡Ë¤Î°ú¿ô¤ËDISTINCT½¤¾þ»ì¤ò¼è¤ë¤Î¤ÏANSI-92 SQL¤Îµ¬³Ê¤Ç¡¢Access¤Ç¤Ï¤½¤ì¤ò»È¤¨¤Ê¤¤¡Ê¡©¡Ë¤½¤¦¤Ç¤¹¡£[1]

¤½¤Î¤¿¤á¡¢Access¤Ç¤Ï¡¢¤³¤ÎSQLʸ¤ÈƱÅù¤Î·ë²Ì¤òÊÖ¤¹¼¡¤Î¤è¤¦¤ÊSQLʸ¤ò»È¤¦É¬Íפ¬¤¢¤ê¤Þ¤¹¡£[1, 2]

SELECT COUNT(°À­2)
  FROM (SELECT DISTINCT °À­2 FROM ¥Æ¡¼¥Ö¥ë1)

Äɵ­¡§¤è¤¯¸«¤¿¤é¡¢Access¤À¤È¥¨¥é¡¼¤Ë¤Ê¤ë¤«¤é¤³¤¦¤·¤Æ¤Í¤Ã¤Æ½ñ¤¤¤Æ¤¢¤ê¤Þ¤·¤¿¡¦¡¦¡¦»î¸³Á°¤Ê¤Î¤Ë²¿¤ä¤Ã¤Æ¤ë¤ó¤À¤í¤¦^^;

¡ã»²¹Í¤Ë¤·¤¿¥Ú¡¼¥¸¡ä
[1] ACC2002: Setting ANSI 92 Compatibility in a Database Does Not Allow DISTINCT Keyword in Aggregate Functions
[2] ½ÅÊ£¤¹¤ëÆâÍƤòcount --Access Club Ķ½é¿´¼Ô FORUM--

Microsoft Office Access 2007 ¥Þ¥¤¥¯¥í¥½¥Õ¥È 2007-03-02 Çä¤ê¾å¤²¥é¥ó¥­¥ó¥° : 346 Amazon¤Ç¾Ü¤·¤¯¸«¤ë by G-Tools

¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯

¥Æ¡¼¥Þ:¥×¥í¥°¥é¥ß¥ó¥° - ¥¸¥ã¥ó¥ë:¥³¥ó¥Ô¥å¡¼¥¿ - ¥½¡¼¥·¥ã¥ë¥Ö¥Ã¥¯¥Þ¡¼¥¯:

NAME:

TITLE:

MAIL:

URL:

COMMENT:


PASS:

SECRET:
´ÉÍý¼Ô¤Ë¤À¤±É½¼¨¤òµö²Ä¤¹¤ë

¥È¥é¥Ã¥¯¥Ð¥Ã¥¯URL
¢ªhttp://networkprogramming.blog18.fc2.com/tb.php/121-13e55a1a
¤³¤Îµ­»ö¤Ë¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¤¹¤ë(FC2¥Ö¥í¥°¥æ¡¼¥¶¡¼)