{"description":"mysql\u306e\u526f\u554f\u5408\u305b\u3067\u3001\u4e0a\u4f4d?\u4ef6\u306e\u5e73\u5747\u3092\u7b97\u51fa\u3057\u3088\u3046\u3068\u3057\u305f\u3089 select avg(val) from (select val from measure_0_hour_day_201202 where member_id=1 order by val desc limit 3) ERROR 1248 (42000): Every derived table must have its own alias \u3068\u3001\u300c\u304d\u3061\u3093\u3068\u30a8\u30a4\u30ea\u30a2\u30b9\u3092\u793a\u3057\u306a\u3055\u3044\u300d\u3068\u6012\u3089\u308c\u305f\u3002 \u3067\u3001\u2193\u3053\u306e\u3088\u3046\u306b select avg(top3.val) from (select val from measure_0_hour_day_\u2026","provider_name":"Hatena Blog","author_name":"end0tknr","blog_title":"end0tknr's kipple - web\u5199\u7d4c\u958b\u767a","author_url":"https://blog.hatena.ne.jp/end0tknr/","categories":["mysql"],"image_url":null,"width":"100%","height":"190","title":"\u4e0a\u4f4d?\u4ef6\u306e\u5e73\u5747\u7b97\u51fa\u3067 Every derived table must have its own alias","provider_url":"https://hatena.blog","version":"1.0","blog_url":"https://end0tknr.hateblo.jp/","published":"2012-03-12 16:35:28","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fend0tknr.hateblo.jp%2Fentry%2F20120312%2F1331537728\" title=\"\u4e0a\u4f4d?\u4ef6\u306e\u5e73\u5747\u7b97\u51fa\u3067 Every derived table must have its own alias - end0tknr&#39;s kipple - web\u5199\u7d4c\u958b\u767a\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","url":"https://end0tknr.hateblo.jp/entry/20120312/1331537728"}