[SQL]データã®ç¸¦æŒã¡ã€æ¨ªæŒã¡ã‚’入れ替ãˆã‚‹ | DevelopersIOã¯ã˜ã‚㫠弊社ã®ãƒ‡ãƒ¼ã‚¿åˆ†æžæ¡ˆä»¶ã«ãŠã„ã¦ã€Redshiftã«ã¦SQLを実行ã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’抽出ã™ã‚‹ã“ã¨ãŒå¢—ãˆã¦ã¾ã„ã‚Šã¾ã—ãŸã€‚SQLã¯ãƒ‡ãƒ¼ã‚¿ã®æŠ½å‡ºã«ã¯å¼·åŠ›ãªã®ã§ã™ãŒã€Javaã‚„Rubyãªã©ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã¨æ¯”ã¹ã‚‹ã¨ç‹¬ç‰¹ã§ã‚ã‚‹ã“ã¨ã‚‚事実ã§ã™ã€‚ 例ãˆã°(PL/SQLãªã©ã¯é™¤ã„ã¦ã§ã™ãŒ) ループãŒãªã„ 変数ã«ä»£å…¥ã—ã¦æ¬¡ã®å‡¦ç†ã«è¡Œãã“ã¨ãŒã§ããªã„ メソッドやクラスã«å‡¦ç†ã‚’分割ã§ããªã„ ãªã©ã§ã™ã€‚ ã“れらã®ç‰¹å¾´ã‹ã‚‰SQLã§ãƒ‡ãƒ¼ã‚¿æŠ½å‡ºã‚’è¡Œã†ç‚ºã«ã¯ã€Javaã‚„Rubyãªã©ã¨ã¯ç•°ãªã£ãŸæ‰‹æ³•ã‚’å–ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ãã“ã§ã€ŒJavaã‚„Rubyã¨ã‹ã§ã¯ãƒ»ãƒ»ãƒ»ã¨ã„ã†ã‚„ã‚Šæ–¹ã§ã‚„ã‚‹ã®ã ã‘ã©ã€SQLã§ã¯ã©ã†ã‚„ã‚‹ã®ã ã‚ã†ã€ã¨ã„ã†ã‚±ãƒ¼ã‚¹ã«ã¤ã„ã¦ã€ã‚·ãƒªãƒ¼ã‚ºå½¢å¼ã§ä½•å›žã‹ã«åˆ†ã‘ã¦å–り上ã’ãŸã„ã¨æ€ã„ã¾ã™ã€‚ å°šã€SQLã®åŸºæœ¬çš„ãªæ§‹æ–‡(selectã€joinã€group byãªã©)ã«ã¤ã„ã¦ã¯èª¬æ˜Žã—ã¾ã›ã‚“。ã¾ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç¨®é¡žã«é–¢ã‚らãšä½¿ç”¨
![[SQL]データã®ç¸¦æŒã¡ã€æ¨ªæŒã¡ã‚’入れ替ãˆã‚‹ | DevelopersIO](https://cdn-ak-scissors.b.st-hatena.com/image/square/d9d7a9e19a3c5979fc0b83efa7beeec666f705bb/height=288;version=1;width=512/https%3A%2F%2Fdevio2023-media.developers.io%2Fwp-content%2Fuploads%2F2015%2F07%2Fsql.png)
{{#tags}}- {{label}}
{{/tags}}