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
19521 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 to create an identity column?

1222

What is an execution plan?

1151

what is raid? : Sql server database administration

1039

Find first and last day of current month in sql server

1028

What is a derived table?

928

Why do we need normalization?

925

What is subreport?

141

How you can get the list of largest tables in a database?

1015

Where are sql server user names and passwords stored in sql server?

1092

How to return the top 5 rows from a select query in ms sql server?

1140

What is efficiency data?

950

What are the advantages of stored procedure in sql server?

892

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

970

How to change server name in sql server?

1184

What is a rollup clause?

968