This can be solved by 2 Ways One way Create unique index on this Tabl

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 / kishor kumar

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

Answer Posted / kishor kumar

This can be solved by 2 Ways

One way

Create unique index on this Table with ignore duplicate row

2nd way.

1st transfer the data to a temp table bu using Distinct
clause then truncate the EMP table and then transfor the
data from temp table to EMP Table.

select distinct (column names) in to #temp from EMP

Truncate table EMP

INSERT INTO EMP

SELECT * FROM #temp

Is This Answer Correct ?

9 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is tablix?

167

How can change procedure in sql server?

1076

What is subquery in sql?

1077

what type of index will get created after executing the above statement? : Sql server database administration

979

Can a trigger be created on a view?

965

Explain the different index configurations a table can have?

960

Do you know nested transaction?

971

What is difference between views and tables?

1025

Explain about Joins?

999

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

998

Explain transaction server auto commit?

1049

What is the optimization being performed in oracle and SQL Server?

1064

What is dirty read?

1091

What is open database communication (odbc)?

1075

How to disable stored procedure sql server?

1617