{"blog_url":"https://kobarin.hateblo.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkobarin.hateblo.jp%2Fentry%2F20091023%2F1256281038\" title=\"SQL\u3067\u6700\u983b\u5024\u3092\u6c42\u3081\u308b - Kobarin&#39;s Development Blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","version":"1.0","image_url":null,"description":"\u300c\u79c1\u306e\u670d\u300d\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u3067\u3001\u6700\u3082\u591a\u3044\u8272\u3092\u6c42\u3081\u308b\u3002 select \u8272, count(*) as \u679a\u6570 from \u79c1\u306e\u670d group by \u8272 having count(*) >= (select max(CNT) from (select count(*) AS CNT from \u79c1\u306e\u670d group by \u8272 ) as C ) \u8272 \u679a\u6570 \u8d64 23 \u2193 \u300c\u201d\u79c1\u306e\u670d\u201d\u306e\u4e2d\u3067\u4e00\u756a\u591a\u3044\u8272\u306f\u201d\u8d64\u201d\u3067\u3001\u8a0823\u679a\u3067\u3057\u305f\u300d \u8ffd\u8a18\u3002\u7c21\u7565\u5316\u7248\u3002 select \u8272 from \u79c1\u306e\u670d group by \u8272 having count(*) >= all(select count(*) AS CNT from \u79c1\u306e\u670d gro\u2026","type":"rich","url":"https://kobarin.hateblo.jp/entry/20091023/1256281038","blog_title":"Kobarin's Development Blog","categories":["SQLserver"],"author_url":"https://blog.hatena.ne.jp/fskkoba/","title":"SQL\u3067\u6700\u983b\u5024\u3092\u6c42\u3081\u308b","height":"190","author_name":"fskkoba","provider_url":"https://hatena.blog","published":"2009-10-23 15:57:18","width":"100%"}