select Distinct * into #Temp_Temp1 from Emp truncate table Emp insert int

I have a table EMP in which the values will be like this

EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30

I want to delete only duplicate Rows. After Delete I want
the output like this

EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30

Question Posted / vikas kant

13 Answers
20007 Views
DELL, I also Faced
E-Mail Answers

Answer Posted / vikas kant

select Distinct * into #Temp_Temp1 from Emp
truncate table Emp
insert into Emp select * from #Temp_Temp1
select * from Emp

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I setup a sql server database?

1129

What stored by the model? : sql server database administration

1005

List out the different types of locks available in sql server?

1032

How will you add a dimension to cube? : sql server analysis services, ssas

1139

What is an inner join?

1045

What is dirty page?

1037

Difference between DELETE and TRUNCATE?

1099

What are the underflow and overflow behaviors on float literals?

1171

New concepts of sql server 2005 use in your project.

2406

What stored by the tempdb ? : sql server database administration

1098

What is rank function?

1086

What do you mean by collation recursive stored procedure?

1112

Explain syntax for viewing trigger?

972

what changed between the previous version of sql server and the current version? : Sql server database administration

1056

Give me any three differences between Truncate and Delete.

1163