以ä¸ã«ç§»è¡ãã¾ããã kenzo0107.github.io
![SlowQuery ãæ¤ç¥ã㦠Explain ã§è§£æã Slack ã¸éç¥ - é·çææ¬é·Engineers'Blog](https://cdn-ak-scissors.b.st-hatena.com/image/square/21a344566a96bac2426004bc7b8118fb71d65e0b/height=288;version=1;width=512/https%3A%2F%2Fcdn-ak.f.st-hatena.com%2Fimages%2Ffotolife%2Fk%2Fkenzo0107%2F20160824%2F20160824165806.png)
以ä¸ã«ç§»è¡ãã¾ããã kenzo0107.github.io
æè¿æ¥åã§google docsãExcelã§ç®¡çãããã·ã¼ãã®å 容ãéè¨ããããã¨ããã£ã¦ãåºæ¬google docsã®ã¹ãã¬ããã·ã¼ãã§ã´ãã§ã´ãã§ãããã¨ãããã®ã§ãããä¾ãã° ã®æ§ãªãã®ããã£ã¦ãä¸ã®ä¾ã ã¨åã¦ã¼ã¶ã®ãã¤ã³ãã®åè¨ãéè¨ããããªã¨èããæã«Excelã«æ £ãã¦ããæ¹ã ã¨Excelã®é¢æ°ãæµ®ããã§éè¨ã§ããã®ãã¨æãã®ã§ããèªåã ã¨SQLæã®ã¤ã¡ã¼ã¸ãå ã«åºãã®ã§ãããªã«ã§ããªãããªã¨æã£ã¦ããããGoogle docsã 㨠QUERY ã¨ããé¢æ°ã使ããã¨ã§å®ç¾ã§ãããã¨ãç¥ã£ãã®ã§ã¡ã¢ã¨ã³ããªã§ãã ä¸ã®ä¾ã 㨠D1 ã®ã»ã«ã«ä»¥ä¸ã®æ§ãªå 容ãè¨è¿°ãã¾ãã =query(A2:B9, "select A, sum(B) group by A") 1çªç®ã®å¼æ°ã«ãã¼ã¿ã®ç¯å²ãæå®ãã2çªç®ã«ãã®ãã¼ã¿ç¯å²ã§ã®ã¯ã¨ãªãè¨è¿°ãã¾ãã SQLã触ã£ããã¨ãããæ¹ãªããªãã¨ãªã
2. 0ç« ãã®è³æã«ã¤ã㦠⢠ãã®è³æã«ã¤ã㦠⢠OâReillyã®SQLã¢ã³ããã¿ã¼ã³åå¼·ä¼ç¨ã®ã¡ã³ã¿ã¼ç¨ã¨ãã¦ä½æ ⢠æ¸ç±ã¨åããã¦å©ç¨ããããã®è³æã§ã ⢠å人ã®ä¸»è¦³ã大ããå ¥ã£ã¦ãã¾ã ⢠ãµã³ãã«ãã¼ã¿ãã¼ã¹ã«ã¤ã㦠⢠SQLã¢ã³ããã¿ã¼ã³æ¸ç±ä¸ xxi ~ xxiii åç § ⢠ãµã³ãã«ã³ã¼ã ⢠http://www.oreilly.co.jp/books/9784873115894/ ⢠bksqla-code.tgz ⢠ãã®ä» ⢠MySQLãåæã«è¨è¼ãã¦ãã¾ãï¼Oracleãå ´åã«ããï¼ 3. 0ç« ã¯ãã㫠⢠xviii ä¸ã®ä¸ã®ã¢ã³ããã¿ã¼ã³ã®å¤ãã«ã¯ã¦ã¼ã¢ã©ã¹ã§åºæ¿çãªã¿ã¤ãã«ãã¤ã ã¦ãã¾ãã ⢠ãé»éã®ãã³ãã¼(Golden Hammer)ã ⢠ãè»è¼ªã®åçºæ(Reinventing the Wheel)ã ⢠ãå§å¡ä¼ã«ããè¨è¨(Des
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}