mysql> select max(id) from (select id from cdr20130330 limit 100,10);
ERROR 1248 (42000): Every derived table must have its own alias
mysql> select max(id) from (select id from cdr20130330 limit 100,10) as tmp;
转载于:https://www.cnblogs.com/lingear/archive/2013/04/03/2998399.html