{"description":"\u9054\u4eba\u306b\u5b66\u3076SQL\u5fb9\u5e95\u6307\u5357\u66f8\u3092\u8aad\u3093\u3067\u3044\u307e\u3059\u3002\u305d\u306eP70\u3067\u3044\u304d\u306a\u308a\u3072\u3063\u304b\u304b\u308a\u3001\u5c11\u3057\u8abf\u3079\u305f\u30e1\u30e2\u3092\u66f8\u304d\u307e\u3059\u3002 id data 1 10 2 10 3 10 4 15 5 15 6 20 7 20 8 20 9 30 10 400 \u88681 : tmp2\u306e\u30e1\u30b8\u30a2\u30f3\u3092\u6c42\u3081\u308b\u306e\u306f select avg(distinct data) from ( select max(t1.id), t1.data from tmp2 t1, tmp2 t2 group by t1.data having sum( case when t2.data >= t1.data then 1 else 0 end ) >= count\u2026","provider_url":"https://hatena.blog","author_name":"niegh","author_url":"https://blog.hatena.ne.jp/niegh/","blog_title":"niegh\u306e\u65e5\u8a18","published":"2009-02-14 00:56:02","version":"1.0","provider_name":"Hatena Blog","type":"rich","height":"190","blog_url":"https://niegh.hatenadiary.org/","categories":["SQL"],"url":"https://niegh.hatenadiary.org/entry/20090214/1234626962","width":"100%","image_url":null,"title":"SQL\u3067\u30e1\u30b8\u30a2\u30f3?","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fniegh.hatenadiary.org%2Fentry%2F20090214%2F1234626962\" title=\"SQL\u3067\u30e1\u30b8\u30a2\u30f3? - niegh\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}