SQL Group By Left([\u5546\u54c1CD], 1) \u3067\u5c0f\u8a08\u3092\u8a08\u7b97\u3059\u308b

{"provider_url":"https://hatena.blog","published":"2017-09-01 00:00:00","blog_title":"\u4e09\u6d41\u541b\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u7f6e\u304d\u5834","categories":["ASP","SQL"],"type":"rich","height":"190","image_url":null,"url":"https://ken3code.hatenablog.jp/entry/2017/09/01/000000","description":"\u5143\u306e\u4e09\u6d41\u89e3\u8aac\u306f\u3001 \u4e09\u6d41\u541bASP:SQL UNION\u6f14\u7b97\u5b50 \u3067 \u8868\u3092\u3064\u306a\u3052\u305f\u30ec\u30b3\u30fc\u30c9\u30bb\u30c3\u30c8\u306e\u4f5c\u6210 \u2191\u3092\u898b\u3066\u3001\u7b11\u3063\u3066\u3084\u3063\u3066\u304f\u3060\u3055\u3044\u3002 \u30d6\u30ed\u30b0\u306b\u904e\u53bb\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u30a2\u30c3\u30d7\u3057\u3066\u3001\u30d6\u30ed\u30b0\u306e\u691c\u7d22\u6a5f\u80fd\u3067\u5229\u7528\u3057\u3066\u307e\u3059(\u5229\u7528\u4e88\u5b9a\u3067\u3059) \u203b\u53e4\u304f\u3055\u3044\u30b3\u30fc\u30c9\u304c\u591a\u3044\u3067\u3059\u30fb\u30fb\u30fb \u30bd\u30fc\u30b9\u30b3\u30fc\u30c9 <%@LANGUAGE=VBScript%> SQL Group By Left([\u5546\u54c1CD], 1) \u3067\u5c0f\u8a08\u3092\u8a08\u7b97\u3059\u308b <\u2026","author_url":"https://blog.hatena.ne.jp/ken3memo/","blog_url":"https://ken3code.hatenablog.jp/","version":"1.0","width":"100%","author_name":"ken3memo","html":"","provider_name":"Hatena Blog","title":"asp075.html \u4e09\u6d41\u541bASP:SQL UNION\u6f14\u7b97\u5b50 \u3067 \u8868\u3092\u3064\u306a\u3052\u305f\u30ec\u30b3\u30fc\u30c9\u30bb\u30c3\u30c8\u306e\u4f5c\u6210"}