[B! sql][database] hiyangã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hiyang id:hiyang

sqlã¨databaseã«é–¢ã™ã‚‹hiyangã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
hiyang 2012/08/31
ã‚·ãƒ³ãƒ—ãƒ«ã§è‰¯ã„ãªãã€‚

java

sql

database
ãƒªãƒ³ã‚¯
å¸°ã£ã¦ããŸHAVINGå¥ï¼šCodeZine
ã¯ã˜ã‚ã« SQLã®ã‚¯ãƒ©ã‚¹ã‚’æ•™ãˆã‚‹ã¨ãã€æœ€å¤§ã®èª²é¡Œã®ä¸€ã¤ãŒã€ç”Ÿå¾’ãŸã¡ãŒãã‚Œã¾ã§ã«æ‰‹ç¶šãåž‹è¨€èªžã‹ã‚‰èº«ã«ä»˜ã‘ãŸã“ã¨ã‚’ã€ä¸€åº¦ã€Œé ã‹ã‚‰è¿½ã„å‡ºã™ï¼ˆunlearnï¼‰ã€ã“ã¨ã ã€‚ç§ãŒãã®ã¨ãæŽ¡ã‚‹ä¸€ã¤ã®æ–¹æ³•ã¯ã€å‡¦ç†ã‚’ã€Œãƒ¬ã‚³ãƒ¼ãƒ‰å˜ä½ã€ã§ã¯ãªãã€é›†åˆã¨ã„ã†è¦³ç‚¹ã‹ã‚‰è€ƒãˆã‚‹ã‚ˆã†å¼·èª¿ã™ã‚‹ã“ã¨ã§ã‚ã‚‹ã€‚ â€•â€•â€•â€•J.ã‚»ãƒ«ã‚³ ã€€SQLã®è€ƒãˆæ–¹ã‚’ç¿’å¾—ã™ã‚‹ã¨ãã«æœ€å¤§ã®éšœå£ã¨ãªã‚‹ã®ãŒã€ç§ãŸã¡ã®å¤šããŒæ…£ã‚Œè¦ªã—ã‚“ã æ‰‹ç¶šãåž‹è¨€èªžã®è€ƒãˆæ–¹ï¼ˆã‚½ãƒ¼ãƒˆã€ãƒ«ãƒ¼ãƒ—ã€åˆ†å²ã€ä»£å…¥ã€ç‰ã€…ï¼‰ã§ã™ã€‚SQLã®æœ¬è³ªã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ç§ãŸã¡ã®å¿ƒã«å¼·å›ºã«è²¼ã‚Šä»˜ã„ã¦ã—ã¾ã£ãŸæ€è€ƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ã€ä¸€åº¦ãƒ™ãƒªãƒ™ãƒªã¨å¼•ãå‰¥ãŒã—ã€æ›´åœ°ã«æˆ»ã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ãã‚ŒãŒã€ã‚»ãƒ«ã‚³ãŒã€Œunlearnã€ã¨ã„ã†è¨€è‘‰ã«è¾¼ã‚ãŸãƒ‹ãƒ¥ã‚¢ãƒ³ã‚¹ã§ã™ã€‚ã‚»ãƒ«ã‚³è‡ªèº«ã€Fortranã‹ã‚‰ãƒ—ãƒã‚°ãƒ©ãƒžã¨ã—ã¦ã®ã‚ãƒ£ãƒªã‚¢ã‚’é–‹å§‹ã—ã€Cã€Algolã€Pascalã¨æ‰‹ç¶šãåž‹è¨€èªžã‚’æ¸¡ã‚Šæ©ã„ãŸå¾Œã«SQLã‚’èº«ã«ä»˜ã‘ãŸäººç‰©ã ã‘ã«ã€è¨€è‘‰ã«
hiyang 2007/07/12
database

sql
ãƒªãƒ³ã‚¯
SQLã§é›†åˆæ¼”ç®—ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€SQLãŒé›†åˆè«–ã«ç«‹è„šã™ã‚‹è¨€èªžã§ã‚ã‚‹ã¨ã„ã†ã“ã¨ã¯ã€ã“ã®é€£è¼‰ã§ä¸€è²«ã—ã¦å¼·èª¿ã—ã¦ããŸãƒ†ãƒ¼ãƒžã®ä¸€ã¤ã§ã™ã€‚ãã®ç‰¹æ€§ã®ã‚†ãˆã«ã€SQLã¯ã€Œé›†åˆæŒ‡å‘è¨€èªžã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã—ã€å®Ÿéš›ã€é›†åˆçš„ãªè¦³ç‚¹ã‹ã‚‰è¦‹ãŸã¨ãã«åˆã‚ã¦ã€ãã®å¼·åŠ›ã•ãŒç†è§£ã§ãã‚‹ã¨ç§ã¯è€ƒãˆã¦ã„ã¾ã™ã€‚ã—ã‹ã—ç¾å®Ÿã«ã¯ã€SQLã®ã“ã®å´é¢ã¯é•·ã‚‰ãç„¡è¦–ã•ã‚Œã¦ãã¾ã—ãŸã€‚ã€€ãã®èƒŒæ™¯ã«ã¯ã€SQLã«ã‚‚è²¬ä»»ã®ä¸€ç«¯ãŒã‚ã‚Šã¾ã™ã€‚ã¨ã„ã†ã®ã‚‚ã€SQLã¯ã¡ã‚‡ã£ã¨å‰ã¾ã§ã€é«˜æ ¡ã§ç¿’ã†ç¨‹åº¦ã®åŸºæœ¬çš„ãªé›†åˆæ¼”ç®—åã™ã‚‰æŒã£ã¦ã„ãªã‹ã£ãŸã‹ã‚‰ã§ã™ã€‚å’Œï¼ˆUNIONï¼‰ã“ãSQL-86ã‹ã‚‰ã®å¤å‚ã§ã™ãŒã€äº¤å·®ï¼ˆINTERSECTï¼‰ã¨å·®ï¼ˆEXCEPTï¼‰ãŒæ¨™æº–ã«å…¥ã£ãŸã®ã¯SQL-92ã§ã™ã—ã€é™¤ç®—ï¼ˆDIVIDE BYï¼‰ãŒæœªã ã«æ¨™æº–åŒ–ã•ã‚Œã¦ã„ãªã„ã“ã¨ã¯ã€å‰ã«ã‚‚è¿°ã¹ã¾ã—ãŸã€‚ã ã‹ã‚‰ã€SQLãŒè¨€èªžã¨ã—ã¦ä¸å®Œå…¨ã ã¨ã„ã†æ‰¹åˆ¤ã¯ã€ç†ç”±ã®ãªã„ã‚‚ã®ã§ã¯ãªã‹ã£ãŸã®ã§ã™ã€‚ã€€ã—ã‹ã—ã€ç¾åœ¨ã§ã¯æ¨™æº–SQLã«åŸºæœ¬çš„ãªé›†åˆæ¼”ç®—å
hiyang 2007/05/31
database

sql
ãƒªãƒ³ã‚¯
http://codezine.jp/a/article.aspx?aid=751
hiyang 2007/01/23
sql

database
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
hiyang 2006/09/08
database

sql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
hiyang 2006/09/07
database

sql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
hiyang 2006/09/07
database

sql
ãƒªãƒ³ã‚¯
è‡ªå·±çµåˆã®ä½¿ã„æ–¹ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€SQLãŒæä¾›ã™ã‚‹çµåˆæ¼”ç®—ã«ã¯ã€ãã®ç‰¹å¾´ã«å¿œã˜ã¦å†…éƒ¨çµåˆã€å¤–éƒ¨çµåˆã€ã‚¯ãƒã‚¹çµåˆãªã©ã•ã¾ã–ã¾ãªåå‰ãŒä¸Žãˆã‚‰ã‚Œã¦ã„ã¾ã™ã€‚æ™®é€šã€ã“ã‚Œã‚‰ã®çµåˆã®å¤šãã¯ã€ç•°ãªã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¾ãŸã¯ãƒ“ãƒ¥ãƒ¼ã‚’å¯¾è±¡ã¨ã—ã¦è¡Œã‚ã‚Œã¾ã™ã€‚ã—ã‹ã—ã€SQLã¯çµåˆãŒåŒä¸€ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¾ãŸã¯ãƒ“ãƒ¥ãƒ¼ã«é©ç”¨ã•ã‚Œã‚‹ã“ã¨ã‚’ç¦æ¢ã—ã¦ã„ã¾ã›ã‚“ã€‚åŒä¸€ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å¯¾è±¡ã«è¡Œã†çµåˆã‚’ã€Œè‡ªå·±çµåˆï¼ˆself joinï¼‰ã€ã¨å‘¼ã³ã¾ã™ã€‚è‡ªå·±çµåˆã¯ã€ä½¿ã„ã“ãªã›ã°éžå¸¸ã«ä¾¿åˆ©ãªæŠ€è¡“ã§ã™ãŒã€å‹•ä½œãŒã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã«ãã„ãŸã‚æ•¬é ã•ã‚ŒãŒã¡ã§ã™ã€‚ãã“ã§æœ¬ç¨¿ã§ã¯ã€ã“ã®è‡ªå·±çµåˆã®ä¾¿åˆ©ã•ã‚’ä¾‹é¡Œã‚’é€šã—ã¦å¦ã³ã€ãã®å‹•ä½œã‚’åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¾ã™ã€‚ã€€è‡ªå·±çµåˆã‚’ç†è§£ã™ã‚‹ã“ã¨ã¯ã€å®Ÿå‹™ä¸Šã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’èº«ã«ã¤ã‘ã‚‹ä»¥å¤–ã«ã€ã‚‚ã†ä¸€ã¤åˆ©ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚ãã‚Œã¯ã€é›†åˆæŒ‡å‘ï¼ˆset-orientedï¼‰ã¨ã„ã†SQLã®é‡è¦ãªç‰¹å¾´ã‚’ç†è§£ã§ãã‚‹ã“ã¨ã§ã™ã€‚ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘è¨€èªžãŒä¸–ç•Œã‚’ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦è¡¨ç¾ã™ã‚‹ã‚ˆã†ã«ã€SQLã¯ä¸–ç•Œ
hiyang 2006/08/16
database

sql
ãƒªãƒ³ã‚¯
CASEå¼ã®ã‚¹ã‚¹ãƒ¡ / ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
hiyang 2006/02/23
ä¾‹é¡ŒãŒã‚¤ã‚¤ï¼

database

sql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
hiyang 2006/02/23
sql

database
ãƒªãƒ³ã‚¯
1