如何实现在同一个表中，将前面的记录复制一遍，ID加1？（不好意思，只有10分）

[Coffy]

A表中N条记录为一组，每组ID值相同，共有M组，如何用语句实现:

取出ID最大的那一组，将ID加1的同时，复制那组数据组成新的记录...

[pengdali]

insert A (id,其他列) select (select max(id) from A)+1,其他列 from A Where id=(select max(id) from A)

[lionstar]

select id+1 as id,anothercolumn into B from A
where id=(select max(id) from a)

开心就好！！！

[txlicenhe]

insert B select id+1 as id,othercolumn from A
where id=(select max(id) from a)

[Coffy]

谢谢楼上各位，一楼和四楼兄台的语句可以正确复制记录，符合我的要求......

结贴...

[zarge]

insert into A
select (select max(id) from A) + 1 as id, col1, col2, ...
from A
Where id = (select max(id) from A)