{"url":"https://3ryupg.hatenablog.com/entry/2018/03/09/200000","height":"190","image_url":null,"author_name":"deloreanmc12","version":"1.0","description":"\u4f8b\u3048\u3070\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002(\u5168\u3066INTEGER\u578b) key num1 num2 1 10 3 2 10 8 3 30 11 \u3067\u3001num2 \u306e num1 \u306b\u5bfe\u3059\u308b\u5272\u5408\u3092SQL\u5b9f\u884c\u6642\u306b\u6c42\u3081\u305f\u3044\u3068\u3057\u307e\u3059\u3002 \u5f53\u521d\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u307e\u3057\u305f\u3002 select key , num1 , num2 , num2/num1 as res from tbl \u3057\u304b\u3057\u3001\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306f\u6574\u6570\u306b\u4e38\u3081\u3089\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u3002 key num1 num2 res 1 10 3 0 2 10 8 0 3 30 11 0 \u3053\u306e\u5834\u5408\u3001REAL\u578b(\u6d6e\u52d5\u5c0f\u6570\u70b9)\u306b\u30ad\u30e3\u30b9\u30c8\u3057\u3066\u3084\u308c\u3070\u3044\u3044\u3088\u3046\u3067\u3059\u3002 cast(\u5217\u540d as \u578b\u540d)\u2026","width":"100%","author_url":"https://blog.hatena.ne.jp/deloreanmc12/","provider_name":"Hatena Blog","blog_url":"https://3ryupg.hatenablog.com/","title":"(SQLite)Select\u53e5\u3067\u8a08\u7b97\u3092\u3057\u305f\u5834\u5408\u306b\u5c0f\u6570\u306b\u3059\u308b\u65b9\u6cd5","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2F3ryupg.hatenablog.com%2Fentry%2F2018%2F03%2F09%2F200000\" title=\"(SQLite)Select\u53e5\u3067\u8a08\u7b97\u3092\u3057\u305f\u5834\u5408\u306b\u5c0f\u6570\u306b\u3059\u308b\u65b9\u6cd5 - 3\u6d41\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u30e1\u30e2\u66f8\u304d\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"3\u6d41\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u30e1\u30e2\u66f8\u304d","categories":["SQL","SQLite"],"provider_url":"https://hatena.blog","type":"rich","published":"2018-03-09 20:00:00"}