{"categories":["SQL","\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0"],"provider_name":"Hatena Blog","published":"2020-12-02 10:19:32","provider_url":"https://hatena.blog","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/h/hanabusa-snow/20201202/20201202101211.png","blog_title":"\u30d7\u30ed\u30b0\u30e9\u751f\u6d3b","title":"\u3010SQL Server(\u9023\u8f09)\u3011CASE\u5f0f -17-","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.pon-x.jp%2Fentry%2F2020%2F12%2F02%2F101932\" title=\"\u3010SQL Server(\u9023\u8f09)\u3011CASE\u5f0f -17- - \u30d7\u30ed\u30b0\u30e9\u751f\u6d3b\" 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://www.pon-x.jp/entry/2020/12/02/101932","width":"100%","author_url":"https://blog.hatena.ne.jp/hanabusa-snow/","height":"190","type":"rich","blog_url":"https://www.pon-x.jp/","author_name":"hanabusa-snow","description":"www.pon-x.jp \u524d\u56de\u306e\u7d9a\u304d \u4eca\u56de\u306f\u3001\u6761\u4ef6\u5206\u5c90\u3092\u76ee\u7684\u3068\u3059\u308bCASE\u5f0f\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 CASE\u5f0f CASE\u5f0f\u306f\u3001\u3082\u3057\u30c7\u30fc\u30bf\u304c\u3001\u3007\u3007\u3060\u3063\u305f\u3089\u00d7\u00d7\u3001\u25b3\u25b3\u3060\u3063\u305f\u3089\u25a1\u25a1\u307f\u305f\u3044\u306a\u304b\u3093\u3058\u306b\u8aad\u307f\u66ff\u3048\u3066\u3042\u3052\u308b\u3053\u3068\u3092\u76ee\u7684\u3068\u3057\u307e\u3059\u3002 \u4fbf\u5229\u306a\u306e\u306f\u3001SELECT\u6587\u3092\u306f\u3058\u3081\u3001UPDATE\u3001DELETE\u3001INSERT\u306a\u3069\u3067\u3067\u3082\u4f7f\u3048\u3001\u3055\u3089\u306bSELECT\u53e5\u3001WHERE\u53e5\u3001ORDER\u53e5\u3001\u306a\u3069\u306a\u3069\u30b9\u30ab\u30e9\u3067\u3042\u3089\u308f\u3055\u308c\u308b\u90e8\u5206\u306a\u3089\u5927\u62b5\u306f\u4f7f\u3048\u308b\u306e\u304c\u7279\u5fb4\u3067\u3059\u3002 \u6587\u6cd5\u306f\u3053\u3093\u306a\u611f\u3058 CASE WHEN [\u6bd4\u8f03\u5143\u30c7\u30fc\u30bf] = [\u6bd4\u8f03\u30c7\u30fc\u30bf] THEN [\u51fa\u529b\u3057\u305f\u3044\u30c7\u30fc\u30bf] WHEN [\u5143\u30c7\u30fc\u30bf] = [\u6bd4\u8f03\u30c7\u30fc\u30bf] THEN [\u51fa\u529b\u3057\u305f\u3044\u2026"}