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
19074 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

How to identify current user in ssrs report?

391

What is an identity column in insert statements?

971

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

917

Does partitioning ssd reduce performance?

850

How many types of local tables are there in sql server?

889

How we create SQL Server 2005 Reporting Services ? Give me Sample

1942

What are the differences between union, intersect, and minus operators?

1019

Does sql server use java?

999

How to use order by with union operators in ms sql server?

969

How to connect Azure federated root database and apply federation in entity framework?

107

Why truncate is ddl?

1031

Does partitioning improve performance sql server?

902

What is the difference between varchar and nvarchar datatypes?

1038

How to enable/disable indexes?

1016

Explain concepts of analysis services?

894