{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fchivsp.hatenablog.com%2Fentry%2F2021%2F07%2F26%2F090000\" title=\"\u52d5\u7684\u306b\u6761\u4ef6\u3092\u5207\u308a\u66ff\u3048\u308bSQL - \u682a\u5f0f\u4f1a\u793e\u30b7\u30d9\u30b9\u30d4\u3000\u5f93\u696d\u54e1\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/chivsp/","published":"2021-07-26 09:00:00","version":"1.0","provider_name":"Hatena Blog","image_url":null,"width":"100%","type":"rich","height":"190","provider_url":"https://hatena.blog","blog_title":"\u682a\u5f0f\u4f1a\u793e\u30b7\u30d9\u30b9\u30d4\u3000\u5f93\u696d\u54e1\u30d6\u30ed\u30b0","blog_url":"https://chivsp.hatenablog.com/","title":"\u52d5\u7684\u306b\u6761\u4ef6\u3092\u5207\u308a\u66ff\u3048\u308bSQL","categories":["\u3084\u3063\u3066\u307f\u305f(\u6280\u8853\u7cfb)"],"description":"\u4eca\u56de\u306f\u524d\u56de\u540c\u69d8\u3001SQL\u3092\u5099\u5fd8\u9332\u304c\u3066\u3089\u7d39\u4ecb\u3057\u307e\u3059\u3002 Oracle\u306b\u3066\u52d5\u7684\u306b\u6761\u4ef6\u3092\u5207\u308a\u66ff\u3048\u308bSQL\u3067\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u306f\u3053\u3093\u306a\u611f\u3058 \u5728\u5eab\u30c6\u30fc\u30d6\u30eb \u533a\u5206 \u5546\u54c1 \u5728\u5eab \u98df\u7269 \u30ea\u30f3\u30b4 20 \u98df\u7269 \u30d0\u30ca\u30ca 10 \u305d\u306e\u4ed6 \u30c9\u30e9\u30a4\u30d0\u30fc 10 \u305d\u306e\u4ed6 \u30bf\u30aa\u30eb 5 \u5728\u5eab\u306b\u95a2\u3057\u3066\u3001\u98df\u7269\u306f10\u4ee5\u4e0b\u3001\u305d\u306e\u4ed6\u306e\u5834\u5408\u306f5\u4ee5\u4e0b\u306e\u6642\u306b\u767a\u6ce8\u3092\u3057\u305f\u3044\u3067\u3059\u3002 \u306a\u306e\u3067\u3001\u4eca\u56de\u306e\u5834\u5408\u306f\u4ee5\u4e0b\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002 \u533a\u5206 \u5546\u54c1 \u5728\u5eab \u98df\u7269 \u30d0\u30ca\u30ca 10 \u305d\u306e\u4ed6 \u30bf\u30aa\u30eb 5 \u6700\u521d\u8003\u3048\u305f\u3068\u304d\u306f\u3053\u3093\u306a\u611f\u3058\u306eSQL\u3092\u60f3\u5b9a\u3057\u3066\u3044\u307e\u3057\u305f\u3002 SELECT * FROM \u5728\u5eab\u30c6\u30fc\u30d6\u30eb WHERE CASE WHEN \u533a\u5206 = \u98df\u7269 THEN \u5728\u5eab <= 10 WHEN \u533a\u2026","author_name":"chivsp","url":"https://chivsp.hatenablog.com/entry/2021/07/26/090000"}