A表
primaryid sn data
1 670302268 <Long Text>
1 670302268 <Long Text>
2 670367805 <Long Text>
2 670367805 <Long Text>
3 670367806 <Long Text>
3 670367806 <Long Text>
4 670367807 <Long Text>
4 670367807 <Long Text>
5 670367808 <Long Text>
5 670367808 <Long Text>
6 670367809 <Long Text>
6 670367809 <Long Text>
7 670367810 <Long Text>
7 670367810 <Long Text>
8 670367811 <Long Text>
8 670367811 <Long Text>
9 670367812 <Long Text>
9 670367812 <Long Text>
10 670367813 <Long Text>
10 670367813 <Long Text>B表 keyword sourcefile primaryid
1800 010$d 2
1800 010$d 2
1980 010$d 10
1980 010$d 10
2000 010$d 1
2000 010$d 5
2000 010$d 1
2000 010$d 5
2007 210$d 11
2007 210$d 15
2007 210$d 19
2007 210$d 20
2007 210$d 11我想将表中重复的部分删除(第一条与第二条重复了)SQL语句怎么谢谢
2007 210$d 15
2007 210$d 19
2007 210$d 20
200701 210$d 6
200701 210$d 6
primaryid sn data
1 670302268 <Long Text>
1 670302268 <Long Text>
2 670367805 <Long Text>
2 670367805 <Long Text>
3 670367806 <Long Text>
3 670367806 <Long Text>
4 670367807 <Long Text>
4 670367807 <Long Text>
5 670367808 <Long Text>
5 670367808 <Long Text>
6 670367809 <Long Text>
6 670367809 <Long Text>
7 670367810 <Long Text>
7 670367810 <Long Text>
8 670367811 <Long Text>
8 670367811 <Long Text>
9 670367812 <Long Text>
9 670367812 <Long Text>
10 670367813 <Long Text>
10 670367813 <Long Text>B表 keyword sourcefile primaryid
1800 010$d 2
1800 010$d 2
1980 010$d 10
1980 010$d 10
2000 010$d 1
2000 010$d 5
2000 010$d 1
2000 010$d 5
2007 210$d 11
2007 210$d 15
2007 210$d 19
2007 210$d 20
2007 210$d 11我想将表中重复的部分删除(第一条与第二条重复了)SQL语句怎么谢谢
2007 210$d 15
2007 210$d 19
2007 210$d 20
200701 210$d 6
200701 210$d 6
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码) http://feiyun0112.cnblogs.com/
2007 210$d 19
2007 210$d 20
下面这2个为什么不删除?也没有这记录
200701 210$d 6
200701 210$d 6
select distinct * from 表
truncate table t
insert into t
select * from #