{"description":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eIMPORTRANGE\u95a2\u6570\u3068QUERY\u95a2\u6570\u306e\u7d44\u307f\u5408\u308f\u305b\u4fbf\u5229\u3067\u3059\u306d\u3002 \u30c7\u30fc\u30bf\u304c\u307e\u3068\u307e\u3063\u305f\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u304a\u3044\u3066\u3001\u5fc5\u8981\u306a\u60c5\u5831\u3092\u3060\u3051\u3092\u8868\u793a\u3055\u305b\u308b\u306e\u306b\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002 \u4eca\u56de \u65e5\u4ed8\u3092\u6761\u4ef6\u306b\u3057\u3066\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3088\u3046\u3068\u3057\u3066\u30cf\u30de\u3063\u305f\u306e\u3067\u30e1\u30e2\u3057\u307e\u3059\u3002 \u4f8b\u3048\u3070A\u5217\u306b\u65e5\u4ed8\u304c\u306f\u3044\u3063\u3066\u3044\u308b\u30b7\u30fc\u30c8\u3092\u53d6\u5f97\u3057\u65e5\u4ed8\u304c2010\u5e741\u670815\u65e5\u4ee5\u964d\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u305f\u3044\u3068\u3057\u307e\u3059\u3002A\u5217\u306fCol1\u3067\u3059 \u4e0b\u8a18\u306e\u3088\u3046\u306a\u66f8\u304d\u65b9\u3092\u3057\u3066\u3082#VALUE!\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002 SELECT * WHERE Col1 > '2010-01-15' \u65e5\u4ed8\u306e\u5165\u3063\u305f\u30bb\u30eb\u3092WHERE\u6587\u3067\u4f7f\u3046\u306b\u306f date 'YYYY-MM-DD'\u306e\u5f62\u5f0f\u306b\u3059\u2026","provider_url":"https://hatena.blog","categories":["Spreadsheet","Google Drive","Tips"],"height":"190","blog_title":"\u304b\u3082\u30e1\u30e2","published":"2016-02-05 17:23:47","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/kikiki-kiki/","blog_url":"https://chaika.hatenablog.com/","type":"rich","version":"1.0","width":"100%","image_url":"http://ecx.images-amazon.com/images/I/61GV5ER70hL.jpg","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fchaika.hatenablog.com%2Fentry%2F2016%2F02%2F05%2F172347\" title=\"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 QUERY\u95a2\u6570\u306e\u6761\u4ef6(WHERE)\u306b\u65e5\u4ed8\u3092\u4f7f\u3044\u305f\u3044\u3002 - \u304b\u3082\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://chaika.hatenablog.com/entry/2016/02/05/172347","author_name":"kikiki-kiki","title":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 QUERY\u95a2\u6570\u306e\u6761\u4ef6(WHERE)\u306b\u65e5\u4ed8\u3092\u4f7f\u3044\u305f\u3044\u3002"}