複数ã®è¡¨ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–り出ã—ã¦è¡¨ç¤ºã•ã›ã‚‹ï¼ˆ1）今回ã¯ã€SQLã®ä¸ã§ã‚‚特ã«é‡è¦ãªæ§‹æ–‡ã§ã‚る「çµåˆã€ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚一言ã§çµåˆã¨ã„ã£ã¦ã‚‚ã€ã„ã‚ã„ã‚ãªã‚„ã‚Šæ–¹ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãšã¯ã€æ¯”較的å˜ç´”ãªæ–¹æ³•ã‹ã‚‰è§£èª¬ã—ã¾ã™ï¼ˆç·¨é›†éƒ¨ï¼‰ 今回ã¨æ¬¡å›žã®2回ã«åˆ†ã‘ã¦ã€SQLã®ä¸ã§ã‚‚ã€æœ€ã‚‚é‡è¦ãªæ§‹æ–‡ã®1ã¤ã§ã‚ã‚‹çµåˆã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚「çµåˆã£ã¦é›£ã—ãã†ã€ã¨ã„ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ãŠæŒã¡ã®æ–¹ã‚‚多ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€1ã¤1ã¤ã®æ§‹æ–‡ã¯ãã‚Œã»ã©è¤‡é›‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“。整ç†ã—ã¦è¦šãˆã¾ã—ょã†ã€‚ 本連載ã§ä½¿ã£ã¦ã„る「apex.oracle.comã€ã®ç’°å¢ƒã«ã¯ã€ŒEMPã€ã€ŒDEPTã€ã¨ã„ã†è¤‡æ•°ã®è¡¨ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆRDB）ã§ã¯ä¸€èˆ¬çš„ãªã“ã¨ã§ã™ã€‚RDBã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸é ˜åŸŸã‚’効率良ã使ã†ãŸã‚ã€ã€Œæ£è¦åŒ–ã€ã¨ã„ã†ãƒ«ãƒ¼ãƒ«ã«å¾“ã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹è¡¨ã‚’複数ã«åˆ†å‰²ã™ã‚‹ã‚ˆã†ã«è¨è¨ˆã—ã¾ã™ã€‚分割ã•ã‚ŒãŸè¤‡æ•°ã®è¡¨ã‹ã‚‰ã€é–¢ä¿‚ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’å–り出ã™ã“ã¨ã‚’「çµåˆã€ã¨å‘¼ã³ã¾ã™ã€‚ çµ
Pandas ã§ãƒ‡ãƒ¼ã‚¿ãƒ•ãƒ¬ãƒ¼ãƒ ã®çµåˆ (マージ, JOIN)
Python 3 string.join() equivalent?
{{#tags}}- {{label}}
{{/tags}}