这两句话可以执行，
create table tt as select name, max(date) from commonprofit group by name;
select rowid,* from tt;
但是我合并成下面的这句话就不行：
select rowid,* from select name, max(date) from commonprofit group by name;
请问，哪里有问题？
------解决方案--------------------
select rowid,* from (select name, max(date) from commonprofit group by name) t;
------解决方案--------------------
select rowid,* from (select name, max(date) from commonprofit group by name) AA ;
------解决方案--------------------
select rowid,* from select name, max(date) from commonprofit group by name;
你这样写，sql解析器无法解析。
应该将后边的 select name, max(date) from commonprofit group by name括起来，表示一个子查询的来源。