SQL 语句。。等待中

[rwx6]

有表TABLE，列为：EMPID NAME
EMPID NAME
1 A
2 B
3 B
4 A
5 C
6 D
1，把有重复的行选出来
2，删除有重复的行（只显示一行）

[hygougou]

是要把哪个字段有重复的行删除吧？


你的表没主键如何设置的

[rwx6]

empid为主键， 对，楼上的理解正确

[peixun]

你想实现什么功能?说出来听听

[hygougou]

select NAME, count(*) from table group by NAME having count(*) > 1

[hygougou]

删除，用delete
就不知道你要删除哪行了？？？

[nimittz]

只要显示吗，用select distinct

[xyqiqi]

显示一行： select NAME from table group by NAME having count(NAME ) > 1
显示重复行中所有记录select * from table where name in (select NAME from table group by NAME having count(NAME ) > 1 group by name)
删除：Delete from table where Empid not in (select Empid from table where name in (select NAME from table group by NAME having count(NAME ) > 1 group by name))

[纸飞机2017]

删除：Delete from table where Empid not in (select Empid from table where name in (select NAME from table group by NAME having count(NAME ) > 1 group by name))

把没重复的记录全删掉了