删除表中重复值,在线等
题目如下:
有一个cj表如下:
id name score
1 a 2
2 h 2
3 t 2
4 a 2
5 h 2
问题:
用sql语句实现删除名字重复记录
结果如下:
id name score
1 a 2
2 h 2
3 t 2
[解决办法]
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)
