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

posted @ 2013-04-03 17:38  J. Lingear  阅读(282)  评论(0编辑  收藏  举报