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

State the difference between local and global temporary tables?

1119

What are views used for?

1014

What is check constraint in sql server?

1002

Explain powershell included in sql server 2008?

1057

When multiple after triggers are attached to sql table, how to control the order of execution?

1049

Is natural join and equi join same?

973

What is SQL Azure Data sync?

121

What is an indexing strategy?

1010

What is standby servers? Explain types of standby servers.

995

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1069

How to bind a view to the schema of the underlying tables?

1001

What is sql server database?

1014

Explain table valued parameters in sql server? Why tvp used?

1019

What is master database? : SQL Server Architecture

1021

what is the different types of backups available in sql server? : Sql server database administration

931