查询用limit获取数据库中部分数据中最大的ID

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/p/2998399.html