这一条SQL怎么写？

[ItOldHorse]

有如下这个表tabel1

dwbm sbkj sbhh

A0126 12 1011
A0126 50 1012
A0126 70 1010


如何生成这样的一个表table2

dwbm sbkj sbhh

A0126 70 1013

要求按dwbm进行汇总生成表 sbkj 要求取最大值，sbhh要求取sbkj取最大值时的sbhh


我是这样一来写的
select max(dwbm) as dwbm,max(sbkj) as sbkj ... from table1
...此处我不知道怎么写啦？

[jacklinchen]

insert into table2(dwbm,sbkj,sbhh) (select dwbm,max(sbkj),max(sbhh)+1 from table1 group by dwbm)

[yangq4000]

select dwbm, max(sbkj) as [sbkj],case when sbkj=max(sbkj) then sbhh else null end)
from tablename group by dwbm

[zjcxc]

select * into table2
from table1 a
where sbkj=(select max(sbkj) from table1 where dwbm=a.dwbm)

[zjcxc]

如果表已经存在,就用:

insert into table2
select * from table1 a
where sbkj=(select max(sbkj) from table1 where dwbm=a.dwbm)

[Doncy]

select * from table1 where sbkj = ( select max(sbkj) from table1)

[dlpseeyou]

如果sbhh 是int整的
select dwbm dwbm ,max(sbkj) sbkj,sbhh=(select max(sbhh)+1 from table1 ) from table1 group by dwbm