Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2006-10-23 : 08:03:09
|
| Hi ,How can i delete the duplicate record from a tableuse Northwindcreate table Emp (Ecode char(2), Ename char(10)) Insert into Emp(Ecode, Ename) values('A1','A')Insert into Emp(Ecode, Ename) values('A1','A')Insert into Emp(Ecode, Ename) values('A2','B')Insert into Emp(Ecode, Ename) values('A2','B')Insert into Emp(Ecode, Ename) values('A3','C')Insert into Emp(Ecode, Ename) values('A3','C')Insert into Emp(Ecode, Ename) values('A4','D')Insert into Emp(Ecode, Ename) values('A4','D')select * from emp order by EcodeThanksASM |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-23 : 08:06:41
|
| [code]SELECT DISTINCT Ecode, Ename INTO #Temp FROM EmpDELETE FROM EmpINSERT Emp SELECT Ecode, Ename FROM #TempDROP TABLE #Temp[/code]Peter LarssonHelsingborg, Sweden |
 |
|
|
asm
Posting Yak Master
140 Posts |
Posted - 2006-10-23 : 08:08:48
|
| There is no primary key.. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-23 : 08:10:19
|
quote:
Originally posted by asm
There is no primary key..
Did you read the link I posted?MadhivananFailing to plan is Planning to fail |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-23 : 15:13:50
|
| INSERT Emp (Ecode, Ename) SELECT Ecode, Ename FROM #TempOK?Peter LarssonHelsingborg, Sweden |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
Delete duplicate record
Wonder what he means by dups thoughBrett8-)Hint: Want your questions answered fast? Follow the direction in this link