有两条纪录
A   B   C   D   E   F  
 1  2   3   4   5   6
 2  A    3  B    C   L

合并这两条纪录,得到的结果是C字段相加,其他字段的值取编号最大的
结果为:2 A 6 B C L

这样如何来实现?

create table tt
(
    A varchar(2),
    B varchar(2),
    C varchar(2),
    D varchar(2),
    E varchar(2),
    F varchar(2)
)
insert into tt values('1','2','3','4','5','6')
insert into tt values('2','A','3','B','C','L')
 
select * from tt
 
select (select top 1 A from tt order by A desc),
(select top 1 B from tt order by B desc),
(select sum(cast(C as int)) from tt),
(select top 1 D from tt order by D desc),
(select top 1 E from tt order by E desc),
(select top 1 F from tt order by F desc)

sql="SELECT max(A) as AA,max(B) as BB,sum(C) as CC,max(D) as DD,max(E) as EE,max(F) as FF FROM 表名"

3楼的大侠比我的简单多了    佩服 佩服