{"categories":["etc"],"blog_title":"\u3050\u308b\u3050\u308b\uff5e","author_name":"bleis-tift","height":"190","author_url":"https://blog.hatena.ne.jp/bleis-tift/","published":"2009-06-23 12:01:46","url":"https://bleis-tift.hatenablog.com/entry/20090623/1245726106","title":"SQL Puzzlers \u3084\u308a\u307e\u3059\uff01","provider_url":"https://hatena.blog","blog_url":"https://bleis-tift.hatenablog.com/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbleis-tift.hatenablog.com%2Fentry%2F20090623%2F1245726106\" title=\"SQL Puzzlers \u3084\u308a\u307e\u3059\uff01 - \u3050\u308b\u3050\u308b\uff5e\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"7 \u6708 25 \u65e5 (\u571f) \u306e\u308f\u3093\u304f\u307e\u540c\u76df \u540d\u53e4\u5c4b\u52c9\u5f37\u4f1a #08\u3067\u30b9\u30d4\u30fc\u30ab\u30fc\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3057\u305f\u3002 \u300cSQL Puzzlers \u301cSQL Server\u7de8\u301c\u300d\u3068\u984c\u3057\u3066\u30014 \u629e\u306e\u30af\u30a4\u30ba\u3092\u3057\u307e\u3059\u3002 \u30af\u30a4\u30ba\u3068\u8a00\u3063\u3066\u3082\u3001\u518d\u5e30 CTE \u306a\u3093\u3066\u4f7f\u308f\u306a\u3044\u6570\u884c\u7a0b\u5ea6\u306e SQL \u3070\u304b\u308a\u306a\u306e\u3067\u5b89\u5fc3\u3057\u3066\u304f\u3060\u3055\u3044\u3002 \u90fd\u5408\u304c\u5408\u3046\u306a\u3089\u662f\u975e\u6765\u3066\u304f\u3060\u3055\u3044\uff01 \u4f8b\u3048\u3070\u3053\u3093\u306a\u554f\u984c\u3092\u51fa\u3057\u307e\u3059\u3002 \u6b21\u306e SQL \u3092\u5b9f\u884c\u3057\u305f\u7d50\u679c\u306f\uff1f -- SQL Server SELECT POWER(0, 0) 0 1 NULL \u30a8\u30e9\u30fc \u7b54\u306f 2 \u306e 1 \u3067\u3059\u3002 \u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u306e\u591a\u304f\u306f 0 \u306e 0 \u4e57\u3092 1 \u3068\u3059\u308b\u307f\u305f\u3044\u3067\u3059\u306d\u3002","type":"rich","width":"100%","provider_name":"Hatena Blog","version":"1.0","image_url":null}