查询用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;
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;