56,678
社区成员
发帖
与我相关
我的任务
分享
insert into tbname2(level,rolename)
select max(level) as maxlevel, rolename
from roles group by accountname
insert into A select * from bname2 where level between 20 and 30;
insert into B select * from bname2 where level between 31 and 40;
insert into A select * from roles where level between 20 and 30;
insert into B select * from roles where level between 31 and 40;
...