2011.02.22 Tuesday | 14:39

  »þ´Ö´ÉÍý¡¢¥ß¡¼¥Æ¥£¥ó¥°¡¢Ä´ºº ¥·¥¹¥Æ¥à²°

¼ÂºÝ¤Î¶È̳¤Ç¤Ï¡¢¥ì¥Ó¥å¡¼¤¬¹Ô¤ï¤ì¤ë²ó¿ô¤Ï¿¤¯Ìµ¤¯¡¢¥×¥í¥°¥é¥Þ¤¬¤½¤ì°Ê¾å¤ËÍ׵ᤵ¤ì¤ë¥¹¥­¥ë¤Ï¡¢Âè°ì¤Ë¡Ö»þ´Ö´ÉÍý¡×¤Ç¤¹¡£Ã¼Åª¤Ë¤Ï¡Ö¥¹¥±¥¸¥å¡¼¥ë´ÉÍý¡×¤È»×¤ï¤ì¤¬¤Á¤Ç¤¹¤¬¡¢¤½¤¦¤Ç¤Ï̵¤¯¡Ö¤½¤Î°ì»þ´Ö¤ò²¿¤Ë»È¤Ã¤¿¤«¡×¤È¤¤¤¦»ö¤òÀµ³Î¤ËÇÄ°®¤¹¤ëɬÍפ¬¤¢¤ë¤È¸À¤¦»ö¤Ç¤¹¡£¥×¥í¥°¥é¥Þ¤Ï¡¢¤½¤Î»þ´Ö¤ÎÁ´¤Æ¤ò¡Ö¥×¥í¥°¥é¥àºîÀ®¡×¤Ë¤¢¤Æ¤Æ¤¤¤ë¤Î¤Ç¤Ï̵¤¯¡¢¹©ÄøÊ̤˻þ´Ö¤ò¾ÃÈñ¤·¤Æ¤¤¤Þ¤¹¡£¤Þ¤¿¡¢Æ±¤¸¹©Äø¤Ç¤â¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤ÎÆñ°×Å٤佬½ÏÅ٤Ǥ«¤«¤ë»þ´Ö¤¬°ã¤Ã¤ÆÍè¤Þ¤¹¡£¤³¤ì¤Ï¡¢»þ´Ö¤È¶¦¤ËÊѲ½¤·¤Æ¹Ô¤¯¤â¤Î¤Ç¤Ï¤¢¤ê¤Þ¤¹¤¬¡¢Åý·×¤ò¼è¤ì¤Ð¤½¤ó¤Ê¤Ë°ã¤Ã¤¿ÃͤϽФº¡¢¾­Íè¤Î¼«Ê¬¤Îºî¶È¤Î¸µ¤È¤Ê¤ë»ñÎÁ¤ä¡¢Êý¸þÀ­¤ò·è¤á¤ëÍ×°ø¤È¤â¤Ê¤ê¤Þ¤¹¡£

ÂèÆó¤ËɬÍפʥ¹¥­¥ë¤Ï¡Ö¥ß¡¼¥Æ¥£¥ó¥°¡×¤Ç¤¹¡£¤³¤ì¤ÏÂç¤Ê¤ê¾®¤Ê¤ê¡¢¤Ä¤Þ¤êÆó¿Í¤Î²ñÏ䫤éÂ礭¤Ê²ñµÄ¤Ë»ê¤ë¤Þ¤ÇÁ´¤ÆƱ¤¸¤Ç¡¢¡ÖɬÍפʾðÊó¤ò¸úΨÎɤ¯ÆÀ¤ë¡×¼êË¡¤òÃΤëɬÍפ¬¤¢¤ê¤Þ¤¹¡£¥ß¡¼¥Æ¥£¥ó¥°¤Ç¤Ï¡¢ÌµÂ̤ò¤Ê¤¯¤¹¤È¸À¤¦¸ú²Ì¤¬¤¢¤ê¡¢¿Í·ïÈñ¤Î¤ß¤ÇÀ®¤êΩ¤Ä¥½¥Õ¥È¥¦¥§¥¢³«È¯¤Ç¤Ï¡¢²ñ¼Ò¤È¸Ä¿ÍξÊý¤Ë¤È¤Ã¤Æ½ÅÍפʰÌÃ֤Ť±¤Ç¤¹¡£

Âè»°¤ËɬÍפʥ¹¥­¥ë¤Ï¡Ö¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Ë¤è¤ëÄ´ººÇ½ÎϡפǤ¹¡£ÀΤϽñÀҤ便ͤËÍê¤ë¤·¤«Ìµ¤«¤Ã¤¿µ»½Ñ¾ðÊó¤â¡¢¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Ç¤Ï´Êñ¤Ë¼ê¤ËÆþ¤ê¤Þ¤¹¡£¤â¤Á¤í¤ó¡¢Î¢¤Å¤±¤Î̵¤¤°ìÈ̾ðÊ󤬤ۤȤó¤É¤Ç¤¹¤¬¡¢¤½¤ì¤Ç¤â¿®Íê¤Î¤ª¤±¤ë¾ðÊó¤Ï¤¿¤¯¤µ¤ó¤¢¤ê¡¢¤½¤ì¤ò¼ÒÆâ¤Ç¸¡¾Ú¤¹¤ì¤Ð½½Ê¬³«È¯¤Î¤µ¤µ¤¨¤È¤Ê¤ê¤Þ¤¹¡£¤â¤Î¤Ë¤è¤Ã¤Æ¤Ï¡¢½é¤á¤Æ¤Î·Ð¸³¤Ç¤â¤«¤Ê¤ê¤Î³ÎΨ¤ÇÍ­ÍѤʾðÊó¤òÆÀ¤ë»ö¤¬¤Ç¤­¤Þ¤¹¡£¤Ç¤¹¤¬¡¢¤³¤ÎÄ´ºº¤Ï°ìÄ«°ìͼ¤Ë¤Ï¹Ô¤«¤º¡¢Æüº¢¤«¤é¤Î·±Îý¤¬É¬Íפˤʤê¤Þ¤¹¡£



2011.02.22 Tuesday | 12:26

  SQL¡£¤ª¤Þ¤È¤á¥ê¥ó¥¯ ¥×¥í¥°¥é¥Þ



  1. inner join
  2. left outer join
  3. Æüì¤Ê·ë¹ç±é»»»Ò : TECHSCORE
  4. sql03_01 ( ¼«¸Ê·ë¹ç ) : ´ÉÍý¼ÔÊ̼Ұ÷°ìÍ÷


  1. ´Ø¿ô
  2. ʸ»úÎó·ë¹ç
  3. 񂯯
  4. ¾ò·ï


  1. group by
  2. having
  3. ¥°¥ë¡¼¥×´Ø¿ô


sql_point_01.png
  • NULL ¤¬´Þ¤Þ¤ì¤ë±é»»¤Ï NULL ¤Ë¤Ê¤ë¤Î¤Ç¡¢¤½¤¦¤Ê¤é¤Ê¤¤¤è¤¦¤Ë´Ø¿ô¤òÍøÍѤ¹¤ë
  • sql01_01 : ½ê°Ê̻ٵë³Û¾ðÊó


sql_point_01.png
  • ½ÅÊ£¤òÇÓ½ü¤¹¤ë¥­¡¼¥ï¡¼¥É¡£SELECT ¹½Ê¸¤È¡¢¥°¥ë¡¼¥×´Ø¿ô¤Ç»ÈÍѤǤ­¤ë
  • sql01_02 : 9·îÅÙÇä¾å¾¦ÉÊ¿ô


sql_point_01.png


sql_point_01.png
  • ¥Ó¥å¡¼¤òºîÀ®¤·¤Ê¤¤¤Ç¡¢µ­½Ò¤Ë¤è¤Ã¤Æ°ì»þŪ¤Ë¥Ó¥å¡¼¤ÈƱÅù¤Î½èÍý¤ò¹Ô¤¦¥Æ¥¯¥Ë¥Ã¥¯( ÉûÌä¹ç¤»¤Î°ì¼ï )


sql_point_01.png
  • SQL µ­½Ò¤Ë¤è¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹Æâ¤Ç¤Î¥Ç¡¼¥¿¤Î¥³¥Ô¡¼ÊýË¡¡£Æó¼ïÎढ¤Ã¤Æ¡¢ÊÒÊý¤Ï ɽ¤µ¤¨¤âºîÀ®¤·¤Æ¤·¤Þ¤¦¡£
  • RDBMS ¤Ë¤è¤Ã¤Æ¤Ï¡¢CREATE ¹½Ê¸¤Ë SELECT ¤ò»ÈÍѤǤ­¤ë
  • »²¹Í SQL¤ÎÁë¥ê¥ó¥¯


sql_point_01.png


sql_point_01.png


sql_point_01.png


sql_point_01.png


sql_point_01.png





2011.02.22 Tuesday | 12:22

  ¥·¥¹¥Æ¥à²°¤Î¥ê¥ó¥¯ ¥·¥¹¥Æ¥à²°


°õºþ½èÍý

¶È̳¥·¥¹¥Æ¥à¤Î³«È¯¥É¥­¥å¥á¥ó¥Èɸ½à²½
¥·¥¹¥Æ¥à³«È¯¤Î²¦Æ»¤ò¶Ë¤á¤ë
Áȹþ¤ß¥½¥Õ¥È¥¦¥§¥¢´ÉÍý¼Ô¡¦µ»½Ñ¼Ô°éÀ®¸¦µæ²ñ
¥¯¥í¥¹¥µ¥¤¥È¥¹¥¯¥ê¥×¥Æ¥£¥ó¥°
¡¡¡¡¥¯¥í¥¹¥µ¥¤¥È¥¹¥¯¥ê¥×¥Æ¥£¥ó¥°Âкö¤Î´ðËÜ¡ÊÁ°ÊÔ¡Ë
¡¡¡¡¥¯¥í¥¹¥µ¥¤¥È¥¹¥¯¥ê¥×¥Æ¥£¥ó¥°Âкö¤Î´ðËÜ¡ÊÃæÊÔ¡Ë
¡¡¡¡¥¯¥í¥¹¥µ¥¤¥È¥¹¥¯¥ê¥×¥Æ¥£¥ó¥°Âкö¤Î´ðËܡʸåÊÔ¡Ë




IT ÍѸ켭ŵ
infoseek ¥Þ¥ë¥Á¼­½ñ
¥Õ¥ê¡¼É´²Ê»öŵ¡Ø¥¦¥£¥­¥Ú¥Ç¥£¥¢¡ÊWikipedia¡Ë¡Ù

¤µ¤Þ¤¶¤Þ¤Ê¥é¥¤¥»¥ó¥¹¤È¤½¤ì¤é¤Ë¤Ä¤¤¤Æ¤Î²òÀâ




2011.02.22 Tuesday | 12:13

  ¥·¥¹¥Æ¥à³«È¯¤È¥ì¥Ó¥å¡¼ ¥·¥¹¥Æ¥à²°

¥·¥¹¥Æ¥à³«È¯¤Î¶È̳¤Ë¥×¥ì¥¼¥ó¥Æ¡¼¥·¥ç¥ó¤È¤¤¤¦ºî¶È¤Ï¸ºß¤·¤Þ¤»¤ó¡£¤¬¡¢Âè»°¼Ô¤«¤é¸«¤¿»þ¡¢
»÷¤¿¤è¤¦¤Ë´¶¤¸¤é¤ì¤ë¤«¤â¤·¤ì¤Ê¤¤¡Ö¥ì¥Ó¥å¡¼¡×¤È¤¤¤¦ºî¶È¤¬¤¢¤ê¤Þ¤¹¡£
¤³¤ì¤Ï¡¢ÀâÌÀ¤¹¤ë¦¤È¤µ¤ì¤ë¦¤È¤¤¤¦Ìò³äʬô¤¬¤¢¤ê¤Þ¤¹¤¬¡¢¤³¤¦¤¤¤¦¾ì¤ò¡Ö¥ì¥Ó¥å¡¼¡×¤È¸À¤¤¤Þ¤¹¡£

ÌÜŪ¤Ï¡¢¥·¥¹¥Æ¥à¤Î¡Ö¸¡¾Ú¡×¤Ê¤Î¤Ç¡¢»²²Ã¼Ô¤Ë¡Ö¸ÜµÒ¡×¤¬´Þ¤Þ¤ì¤ë»ö¤â¤¢¤ê¤Þ¤¹¤¬¡¢¡Ö¸¡¾Ú¡×
¤¹¤ë»ö¤¬¤Ç¤­¤ë¡Ö¥¹¥­¥ë¡×¤ò½êÍ­¤·¤Æ¤¤¤ë¿Í¤Ç¤Ê¤±¤ì¤Ð°ÕÌ£¤Ï¤¢¤ê¤Þ¤»¤ó¡£Â¿¤¯¤Ï¡¢³«È¯¼Ô
Ʊ»Î¤Ë¤è¤ë¡Ö¥Á¥§¥Ã¥¯¡×¤Ë¤è¤Ã¤ÆÌäÂêÅÀ¤ò¹Í»¡¤·¤¿¤ê¡¢Äó°Æ¤ò¹Ô¤Ã¤¿¤ê¤¹¤ëºî¶È¤Ë¤Ê¤ê¤Þ¤¹¡£

½é¿´¼Ô¤Î¾ì¹ç¡¢¡Ö¸½¾õ¤òÀµ¤·¤¯Êó¹ð¤¹¤ë¡×¤È¤³¤í¤«¤é»Ï¤Þ¤ê¤Þ¤¹¡£¤³¤Î»þ¤Ë»È¤ï¤ì¤ë¼êË¡
¤È¤·¤Æ¡¢°ìÈÌŪ¤Ê¡Ö¥×¥ì¥¼¥ó¥Æ¡¼¥·¥ç¥ó¡×¤Î¼êË¡¤¬ÍѤ¤¤é¤ì¤ë»ö¤ÏÉáÄ̤ʤΤǡ¢½àÈ÷¤¹¤ë¤â¤Î¤ä
ÏýѤËÂФ·¤Æ¤Ï¡Ö·±Îý¡×¤¬É¬Íפˤʤê¤Þ¤¹¡£¤¿¤À¡¢ÌÜŪ¤Ï¤¢¤¯¤Þ¤Ç¡Ö»ö¼Â¤òÅÁ¤¨¤ë¡×»ö¤Ë¤¢¤Ã¤Æ¡¢
ʹ¤­¼ê¤ÎÅÔ¹çÅù¤ò¹Íθ¤¹¤ëɬÍפϤ¢¤ê¤Þ¤»¤ó( ÀìÌçÍѸì¤ò»È¤¤¤Þ¤¹ )





1/1