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

kohagi id:kohagi

sqlã«é–¢ã™ã‚‹kohagiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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}}

ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
kohagi 2009/02/17
sql
ãƒªãƒ³ã‚¯
SQLã®è«–ç†å½¢å¼ - ãƒŸãƒƒã‚¯ã®ãƒ–ãƒã‚°
æ–°äººã®åãŸã¡ã« SQL ã‚’æ•™ãˆã¦ãã¾ã—ãŸã€‚GROUP BY ã®ã‚ãƒ¼ã«æŒ‡å®šã—ã¦ã„ãªã„åˆ—åã‚’SELECTå¥ã«æ›¸ã„ã¦ã¯ã„ã‘ãªã„ã€ã¨ã„ã†ç¦å‰‡ã®æ„å‘³ãŒã‚ˆãç†è§£ã§ããšã«å›°ã£ã¦ã„ã‚‹ä¾‹ã‚’å¤šãè¦‹ã‹ã‘ã¾ã—ãŸã€‚ç‰¹ã«ã€GROUP BYå¥ã§åˆ—ã«CASEå¼ã‚’ä½¿ã£ãŸå ´åˆã€ã‚‚ã¯ã‚„ãã‚Œã¯ã‚ãƒ¼ã¨ã—ã¦å…ƒã®åˆ—ã¨ã¯åŒã˜ã§ã‚ã‚Šãˆãªã„ã€ã¨ã„ã†ã¨ã“ã‚ã®ç†è§£ãŒé›£ã—ã‹ã£ãŸã‚ˆã†ã€‚ ä¸€èˆ¬ã«ã€GROUP BYå¥ã‚’æŒ‡å®šã—ãŸã‚‰ã€SELECTå¥ã«æ›¸ã‘ã‚‹è¦ç´ ã¯ä¸‰ç¨®é¡žã«åˆ¶é™ã•ã‚Œã¾ã™ã€‚ GROUP BYã§æŒ‡å®šã—ãŸé›†ç´„ã‚ãƒ¼ é›†ç´„é–¢æ•° å®šæ•° ãã†ã„ãˆã°ç§ã‚‚åˆå¿ƒè€…ã®ã“ã‚ã€ã“ã®åˆ¶é™ã®å¿…ç„¶æ€§ãŒåˆ†ã‹ã‚‰ãªãã¦æ‚©ã‚“ã è¨˜æ†¶ãŒã‚ã‚Šã¾ã™ã€‚GROUP BYãŒãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ãƒ»ã‚«ãƒƒãƒˆã®æ©Ÿèƒ½ã‚’æžœãŸã™ã€ã¨ã„ã†ã“ã¨ã‚’ã‚¤ãƒ¡ãƒ¼ã‚¸ã§ãã‚Œã°ã€ã“ã®ç¨®ã®ç–‘å•ã¯è§£æ¶ˆã™ã‚‹ã®ã§ã™ãŒã€ãã‚ŒãŒèº«ä½“æ„Ÿè¦šã¨ã—ã¦èº«ã«ã¤ãã®ã¯ã¡ã‚‡ã£ã¨ã‹ã‹ã‚Šãã†ã€‚ SQL ã‚’æœ€åˆã«å¦ã¶ã¨ãã€ã“ã®ã‚ãŸã‚Šã§æ··ä¹±ã—ã‚„ã™ã„ã®ã¯ã€ãã£ã¨SQLã‚’æ›¸ã
kohagi 2009/02/17
ã€ŒSQLã®å®Ÿè¡Œé †åºã¯ã€FROM â†’ WHERE â†’ GROUP BY â†’ HAVING â†’ SELECT ï¼ˆâ†’ ORDER BYï¼‰ã§ã™ã€

sql
ãƒªãƒ³ã‚¯
ç´ æ—©ãæ£è¦å½¢ã‚’è¦‹æŠœãå®Ÿè·µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼ˆ1/4ï¼‰ ï¼ ï¼ IT
ä»Šå›žã®ãƒ†ãƒ¼ãƒžã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å¿…é ˆçŸ¥è˜ã®1ã¤ã§ã‚ã‚‹ã€Œæ£è¦åŒ–ã€ã§ã™ã€‚æ£è¦åŒ–ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’è¡Œã†ã†ãˆã§éžå¸¸ã«é‡è¦ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã§ã‚ã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¨è¨ˆã€å®Ÿè£…ã—ãŸã“ã¨ã®ã‚ã‚‹æ–¹ãªã‚‰ä¸€åº¦ã¯æ£è¦åŒ–ã«è§¦ã‚Œã¦ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ãã‚Œã»ã©åŸºæœ¬çš„ãªçŸ¥è˜ã§ã‚ã‚‹ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€æ£è¦åŒ–ã‚’èª¬æ˜Žã§ãã‚‹äººã¯ãªã‹ãªã‹ã„ã¾ã›ã‚“ã€‚å¤šãèžã‹ã‚Œã‚‹ã®ãŒã€Œä½•ã¨ãªããƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã¨è‡ªç„¶ã«ç¬¬3æ£è¦å½¢ã«ãªã‚‹ã€ã¨ã‹ã€Œå®Ÿå‹™ä¸Šã¯ç¬¬3æ£è¦åŒ–ã¾ã§è¡Œãˆã°å•é¡Œãªã„ã€ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ ã§ã¯ãªãœã€Œç¬¬3æ£è¦åŒ–ã¾ã§è¡Œãˆã°å•é¡Œãªã„ã€ã®ã§ã—ã‚‡ã†ã‹ã€‚æœ¬ç¨¿ã§ã¯ã²ã¨ã¨ãŠã‚Šæ£è¦åŒ–ã«ã¤ã„ã¦ç¢ºèªã—ãªãŒã‚‰ã€ã‚ã¾ã‚Šè§¦ã‚Œã‚‰ã‚Œã‚‹ã“ã¨ã®ãªã„ç¬¬3æ£è¦åŒ–ã‚ˆã‚Šå…ˆã®æ£è¦åŒ–ã‚’ç´¹ä»‹ã—ã¦ã€ã“ã®ç–‘å•ã«ç”ãˆã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ æ£è¦åŒ–ã®ä½ç½®ä»˜ã‘ æ£è¦åŒ–ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆå…¨èˆ¬ã«ã‹ã‹ã‚ã‚‹åŸºç¤ŽçŸ¥è˜ã§ã™ãŒã€ç‰¹ã«è«–ç†ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ä½œæ¥ã®ä¸ã§å¿…è¦ã«ãªã‚Šã¾ã™ã€‚æœ¬ç¨¿
kohagi 2009/02/09
sql
ãƒªãƒ³ã‚¯
SQL -TECHSCORE-
ã“ã“ã§ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã«å¿…é ˆã¨ãªã‚‹ä¸–ç•Œæ¨™æº–è¨€èªž SQL ã«ã¤ã„ã¦ã€åŸºç¤Žã‹ã‚‰å¿œç”¨ã¾ã§è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ ã¾ãŸã€SQL ã®ã¿ã«ã¨ã©ã¾ã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ¡ãƒ³ãƒˆã‚·ã‚¹ãƒ†ãƒ (RDBMS) ã®æŒã¤æ§˜ã€…ãªæ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ æœ€å¾Œã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã«é–¢ã™ã‚‹éžå¸¸ã«é‡è¦ãªè€ƒãˆæ–¹ã«ã¤ã„ã¦ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ã®ã§ã€ã“ã‚Œã‚‰ã‚’å…¨ã¦å¦ç¿’ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œã‹ã‚‰è¨è¨ˆã¾ã§å¹…åºƒã„çŸ¥è˜ã‚’èº«ã«ã¤ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã§ã—ã‚‡ã†ã€‚ SQL INDEX 1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¦‚è¦ 1.1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ 1.2. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ç‰¹å¾´ 1.3. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ•ã‚¡ã‚¤ãƒ«ã®é•ã„ 1.4. ä»£è¡¨çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« 1.5. ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 1.6. ã¾ã¨ã‚ 2. SQL 2.1. SQL ã®æ´å² 2.2. SQL ã¨ã¯ 2.3. SQL ã®æ©Ÿèƒ½ 2.
kohagi 2009/01/17
sql
ãƒªãƒ³ã‚¯
SQLå…¥é–€
ã‚ãªãŸãŒSQLã®åˆå¿ƒè€…ã§ã‚ã‚Œã€ SQLã‚’ã¡ã‚‡ã£ã¨å¾©ç¿’ã—ãŸã„ãƒ‡ãƒ¼ã‚¿ ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹æ¥ç•Œã®çµŒé¨“è±Šã‹ãªäººã§ã‚ã‚Œã€ã„ã„ã¨ã“ã‚ã«æ¥ã‚‰ã‚Œã¾ã—ãŸã€‚ã“ã® SQLæ•™æã®ã‚µã‚¤ãƒˆã¯ã€ã‚ˆãä½¿ã‚ã‚Œã‚‹ SQL ã‚³ãƒžãƒ³ãƒ‰ãŒæŽ²è¼‰ã—ã¦ã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚µã‚¤ãƒˆã¯ä»¥ä¸‹ã®ã‚ˆã†ã«åˆ†ã‹ã‚Œã¾ã™ã€‚ - SQL ã‚³ãƒžãƒ³ãƒ‰: SQL ãŒã©ã®ã‚ˆã†ã«ä¿å˜ã€èªã¿è¾¼ã¿ã€åˆã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã«ä½¿ã‚ã‚Œã‚‹ã“ã¨ã€‚ - ãƒ†ãƒ¼ãƒ–ãƒ«å‡¦ç†: ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã«SQL ãŒã©ã®ã‚ˆã†ã«ä½¿ã‚ã‚Œã‚‹ã“ã¨ã€‚ - SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°: å½“è©²æ•™æã«æç¤ºã•ã‚Œã‚‹ SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’ç¤ºã™ãƒšãƒ¼ã‚¸ã€‚ å„ã‚³ãƒžãƒ³ãƒ‰ã«ã¤ã„ã¦ã¯ã€ã‚ã‚‰ã‹ã˜ã‚ã€å½“è©²ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’ç¤ºã—ã€èª¬æ˜Žã—ã¾ã™ã€‚ãã‚Œã‹ã‚‰ã€ãã®ã‚³ãƒžãƒ³ãƒ‰ã®ä½¿ã„æ–¹ã‚’ã‚ˆãç†è§£ã•ã›ã‚‹ã‚ˆã†ã«ã€ä¾‹ã‚’ä¸€ã¤æŒ™ã’ã¾ã™ã€‚ã“ã®ã‚µã‚¤ãƒˆã«ãŠã‘ã‚‹ã™ã¹ã¦ã®æ•™æã‚’èªã¿çµ‚ãˆãŸã¨ãã€ SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«ã¤ã„ã¦ã€å¤§ã¾ã‹ãªç†è§£ãŒã§ãã‚‹ã¯ãšã ã¨æ€ã„ã¾ã™ã€‚ ãã—
kohagi 2009/01/17
sql
ãƒªãƒ³ã‚¯
ã€YQL é€Ÿæ”»ãƒ¬ãƒ“ãƒ¥ãƒ¼ã€‘ç±³ Yahoo! ãŒ SQL ã£ã½ãè‰²ã‚“ãªãƒ‡ãƒ¼ã‚¿ã‚’å–ã£ã¦ã“ã‚Œã‚‹APIã‚’å‡ºã—ãŸ - ã¦ã£ãç…®ãƒ–ãƒã‚°
ç±³ Yahoo! ãŒ Yahoo! Pipes ã¿ãŸã„ã«è‡ªç”±åº¦ãŒé«˜ãã¦ã€ã¾ãŸã¡ã‚‡ã£ã¨æ¯›è‰²ãŒé•ã†ã‚µãƒ¼ãƒ“ã‚¹ãŒå‡ºã¦ããŸã€‚é¡Œã—ã¦ã€Yahoo! Query Languageã€‚YQL ã¨å‘¼ã¶ã‚ˆã†ã ã€‚SQL é¢¨ã®è¨€èªžã‚’ REST ã§æŠ•ã’ã¦ã€çµæžœã‚’ XML ã‚„ JSON ã§å—ã‘å–ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚å…·ä½“çš„ã«ã‚„ã£ã¦ã¿ãªã„ã¨åˆ†ã‹ã‚Šã«ãã„ã®ã§ã€ã¨ã‚Šã‚ãˆãšè©¦ã—ã¦ã¿ãŸã€‚RSS ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿å–å¾—YQL ã‚’ä½¿ã£ã¦ RSS ã‹ã‚‰æœ€æ–°ã®ã‚¿ã‚¤ãƒˆãƒ«10å€‹ã‚’å–ã£ã¦ãã¦ã¿ã‚‹ã€‚ã“ã‚“ãª YQL ã«ãªã‚‹ã‚‰ã—ã„ã€‚ select title from rss where url='http://d.hatena.ne.jp/nitoyon/rss' rss ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ select ã‚’ç™ºè¡Œã—ã¦ã„ã‚‹ã€‚å®Ÿéš›ã«ã“ã® YQL ã‚’è©¦ã™ã«ã¯ YQL ç”¨ã® console ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã‚ˆã„ã€‚ï¼ˆâ€»è¦ãƒã‚°ã‚¤ãƒ³ï¼‰console ã®å·¦ä¸Šã« YQL ã‚’å…¥åŠ›ã—ã¦
kohagi 2008/12/15
JavaScript

ajax

sql
ãƒªãƒ³ã‚¯
1