有个test表 ,tid自动+1
tid num
1 aaa
2 bbb
3 aaa
4 bbb
5 ccc如何能把重复的全删除,一条不留,select num from test group by num having count(*)<>1 这条语句还保留了一条要的结果是
tid num
5 ccc
tid num
1 aaa
2 bbb
3 aaa
4 bbb
5 ccc如何能把重复的全删除,一条不留,select num from test group by num having count(*)<>1 这条语句还保留了一条要的结果是
tid num
5 ccc
from test
where num in(select num from test t group by num having (count)>1)
from tc
where num in(select num from tc t group by num having
count(*)>1)