SQL 表中查询其中一个字段相同,另外一字段取最大值的语句,并且附带第三...答:create table #test(id int,a varchar(100),b int);insert into #test values (1,'a',100)insert into #test values (1,'b',200)insert into #test values (2,'A',100)insert into #test values (2,'B',500)insert into #test values (2,'D',500)select * from #test aa where...