日期:2014-05-17 浏览次数:20594 次
create table #test
(
xuehao nvarchar(100),
chengji int
)
insert into #test
select '20110001',55 union all
select '20110002',45 union all
select '20110002',85 union all
select '20110003',35 union all
select '20110003',65 union all
select '20110003',89
select * from #test
select xuehao,min(chengji) chengji from #test group by xuehao