create table T_test
(
A varchar(5),
B varchar(5),
C varchar(20)
)
goinsert into T_test values('001','aa','4354')
insert into T_test values('001','bb','qwe')
insert into T_test values('001','cc','rtywe')
insert into T_test values('002','dd','vbnvbgtfh')
insert into T_test values('002','ee','nbvn')
insert into T_test values('002','ff','ewrwer')
insert into T_test values('002','aa','afdv')
goselect A,Max(B),Max(C)
from T_test
group by A
(
A varchar(5),
B varchar(5),
C varchar(20)
)
goinsert into T_test values('001','aa','4354')
insert into T_test values('001','bb','qwe')
insert into T_test values('001','cc','rtywe')
insert into T_test values('002','dd','vbnvbgtfh')
insert into T_test values('002','ee','nbvn')
insert into T_test values('002','ff','ewrwer')
insert into T_test values('002','aa','afdv')
goselect A,Max(B),Max(C)
from T_test
group by A
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货