一句简单的SQL

insert into Table2(Id,Name,Score,Memo)
(
select Id,Name,Score,Memo from Table1 where id not in
(select id from Table1 a where score<(select max(score) from Table1 b where a.name=b.name))
)

题目就不写了  呵呵