[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:6495

From: NAGASAWA Teruo <NAGASAWA Teruo <ml@xxxxxxxxxx>>
Date: Thu, 31 Oct 2002 15:52:10 +0900
Subject: [mysql 06495] Re: ¥µ¡¼¥Ð¥¹¥Ú¥Ã¥¯¤Ë¤Ä¤¤¤Æ

ĹÂô¤Ç¤¹¡£

|­¡¥Æ¡¼¥Ö¥ë
|¡¡¹àÌܤÎŤµ¤Ï̤Äê¤Ç¤¹¡£¡Ê¤Ç¤â¡¢¹àÌܤÎÀ­¼Á¾å¤½¤ì¤Û¤ÉŤ¯¤Ï¤Ê¤é¤Ê¤¤¤È»×¤¤¤Þ¤¹¡£¡Ë
|¡¡¡¦²ñ°÷¥Æ¡¼¥Ö¥ë[member]
|¡¡¡Ê£É£Ä¡¤Password¡¤¸ÜµÒÈֹ桤ÅÅÏÃÈֹ桤²ñ°÷»á̾¡¤²ñ°÷»á̾¥«¥Ê¡Ë
|¡¡¡¦ÌÀºÙ¥Æ¡¼¥Ö¥ë[detail]¡ß£¶¡§£±¥Æ¡¼¥Ö¥ë¡¿·î
|¡¡¡Ê¸ÜµÒÈֹ桤ÍøÍÑÆü»þ¡¤ÍøÍÑÈֹ桤ÍøÍÑ»þ´Ö¡¤ÍøÍÑÎÁ¶â¡Ë
|­¢¸¡º÷¤Î¤¿¤á¤ÎSQLʸ
|¡¡¡¦°ìÍ÷½ÐÎÏ
|¡¡select * from detail where ¸ÜµÒÈÖ¹æ = ¡²¡²¡² order by ÍøÍÑÆü»þ;
|
|¡¡¡¦°ìÍ÷½ÐÎÏ¡§Ê¤ÓÂؤ¨
|¡¡select * from detail where ¸ÜµÒÈÖ¹æ = ¡²¡²¡² order by ÍøÍÑÈÖ¹æ ;
|¡¡select * from detail where ¸ÜµÒÈÖ¹æ = ¡²¡²¡² order by ÍøÍÑ»þ´Ö ;
|
|¡¡¡¦½¸·×
|¡¡¡¡select ÍøÍÑÈֹ桤sum(ÍøÍÑ»þ´Ö)¡¤sum(ÍøÍÑÎÁ¶â) from detail where ¸ÜµÒ
|ÈÖ¹æ = ¡²¡²¡²
|¡¡¡¡¡¡group by ÍøÍÑÈÖ¹æ
|¡¡¡¡¡¡order by sum(ÍøÍÑÎÁ¶â) ;
|­£¥¤¥ó¥Ç¥Ã¥¯¥¹
|¡¡¤Þ¤À¡¢·èÄꤷ¤Æ¤¤¤Þ¤»¤ó¤¬°Ê²¼¤ÎÍѤ˹ͤ¨¤Æ¤¤¤Þ¤¹¡£
|¡¡¡¦²ñ°÷¥Æ¡¼¥Ö¥ë[member]
|¡¡¡¡£É£Ä¡¤Password¡¤¸ÜµÒÈÖ¹æ
|¡¡¡¦ÌÀºÙ¥Æ¡¼¥Ö¥ë[detail]
|¡¡¡¡¸ÜµÒÈÖ¹æ

¤ó¡Á¡¢¤¶¤Ã¤È¸«¤¿´¶¤¸¤Ç¤Ï¡¢Á´Á³Í¾Íµ¤¸¤ã¤Ê¤¤¤«¤Ê¡Á¤È»×¤¤¤Þ¤¹¡£

ÌäÂê¤ÏMySQL¤Ç¤Ï¤Ê¤¯¡¢MySQL¤È¤Î¥³¥Í¥¯¥·¥ç¥ó¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡©
¤É¤ó¤Ê¸À¸ì¤ò»È¤¦¤Î¤«Ê¬¤«¤ê¤Þ¤»¤ó¤¬¡¢¥³¥Í¥¯¥·¥ç¥ó¥×¡¼¥ë¤ò»È¤¨¤ì¤Ð¡¢
;͵(¡©)¤Ç½èÍý¤Ç¤­¤ë¥ì¥Ù¥ë¤À¤È¡¢Ëͤϴ¶¤¸¤Þ¤¹¡£



-- 
NAGASAWA Teruo <ml@xxxxxxxxxx>


[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

      6488 2002-10-31 11:54 [<antoku@xxxxxxxxxx> ] Re: ¥µ¡¼¥Ð¥¹¥Ú¥Ã¥¯¤Ë¤Ä¤¤¤Æ              
->    6495 2002-10-31 15:52 ¨±[NAGASAWA Teruo <ml@x]