create table T(id int, name char(1), score int)
insert T select 1, 'a', 2
union all select 2, 'h', 2
union all select 3, 't', 2
union all select 4, 'a', 2
union all select 5, 'h', 2
delete T
where id not in(
select min(id) from T group by name
)select * from T--result
id name score
----------- ---- -----------
1 a 2
2 h 2
3 t 2(3 row(s) affected)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货