ID NAME
1 zhanglei
2 wanglei
3 hao
4 haoren
5 haha
6 zhanglei
7 zhanglei我想删除 ID 不一样,但是名字是一样的重复行,留取其中一行。
1 zhanglei
2 wanglei
3 hao
4 haoren
5 haha
6 zhanglei
7 zhanglei我想删除 ID 不一样,但是名字是一样的重复行,留取其中一行。
调试欢乐多
INSERT @T SELECT 1,'zhanglei'
UNION ALL SELECT 2,'wanglei'
UNION ALL SELECT 3,'hao'
UNION ALL SELECT 4,'haoren'
UNION ALL SELECT 5,'haha'
UNION ALL SELECT 6,'zhanglei'
UNION ALL SELECT 7,'zhanglei'----
DELETE A
FROM @T A
WHERE EXISTS
(SELECT 1 FROM @T WHERE NAME=A.NAME AND ID<A.ID )
--result
SELECT * FROM @T
(select DISTINCT id from table1 )
INSERT TableA SELECT 1,'zhanglei'
UNION ALL SELECT 2,'wanglei'
UNION ALL SELECT 3,'hao'
UNION ALL SELECT 4,'haoren'
UNION ALL SELECT 5,'haha'
UNION ALL SELECT 6,'zhanglei'
UNION ALL SELECT 7,'zhanglei'delete from tableA where ID not in(select min(ID) as ID from tableA group by Name,ID)