SQL | pascalã®æ—¥è¨˜ | スラドã¿ãŸã„ãªãƒ†ãƒ¼ãƒ–ルã‹ã‚‰ã€(x, 1), (x, 2)ã‚’ã¨ã‚‚ã«å«ã‚€ã‚ˆã†ãªxを全列挙ã™ã‚‹SQLæ–‡ã¯?ã£ã¦è©±ã«ã€‚ 1. (SELECT DISTINCT a FROM hoge WHERE b = 1) INTERSECT (SELECT a FROM hoge WHERE b = 2); å•é¡Œã®å®šç¾©ã«å¿ 実。MySQLã¨ã‹ã ã¨INTERSECTã«å¯¾å¿œã—ã¦ãªã„ã®ãŒé›£ç‚¹ã€‚内部的ã«ã¯ãƒ†ãƒ¼ãƒ–ルを段階的ã«å°ã•ãã—ã¦ã„ãã®ã‹ãªãƒ¼ã€‚ 2. SELECT DISTINCT t1.a FROM hoge t1, hoge t2 WHERE t1.a = t2.a AND t1.b = 1 AND t2.b = 2; 1個上ã®SQL文をã€INTERSECTを使ã‚ãªã„よã†ã«ã”ã¾ã‹ã—ãŸæ„Ÿã˜ã€‚INNER JOINを内部ã§ã©ã†ã‚„ã£ã¦ã‚‹ã‹ã¯çŸ¥ã‚‰ãªã„ã‘ã©ã€ãã£ã¨ANDを見ãªãŒã‚‰å‡¦ç†ã—ã¦ãれるã‹ã‚‰1.より速ã„ã‚“ã˜ã‚ƒãªã„ã‹ãªãƒ¼ã¨æ€ã†
{{#tags}}- {{label}}
{{/tags}}