end0tknr https://blog.hatena.ne.jp/end0tknr/ end0tknr's kipple - web写経開発 https://end0tknr.hateblo.jp/ mysql mysqlの副問合せで、上位?件の平均を算出しようとしたら 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 と、「きちんとエイリアスを示しなさい」と怒られた。 で、↓このように select avg(top3.val) from (select val from measure_0_hour_day_… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fend0tknr.hateblo.jp%2Fentry%2F20120312%2F1331537728" title="上位?件の平均算出で Every derived table must have its own alias - end0tknr&#39;s kipple - web写経開発" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2012-03-12 16:35:28 rich https://end0tknr.hateblo.jp/entry/20120312/1331537728 1.0 100%