Google docsã®ã¹ãã¬ããã·ã¼ãã§éè¨ããéã«SQLã£ã½ãã¯ã¨ãªã使ã
æè¿æ¥åã§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ã触ã£ããã¨ãããæ¹ãªããªãã¨ãªããããè¨è¿°å 容ãã¨æãã¾ããå ¥åãå®äºããã¨ããã«ã»ã«ã«éè¨çµæãåæ ããã¾ãã
ãªãã»ã©ã¨ã¦ã便å©ãGoogle docsåæããã®æ©è½ã ã£ãæ§ãªã®ã§ããæ¬æ ¼çã«æè¿è§¦ãæ§ã«ãªã£ãã®ã§ãã£ã¨ä¾¿å©ãã«æ°ã¥ãã¾ããã
åç §
Query Language Reference (Version 0.7) | Charts | Google Developers