Can be done in a simple way. DELETE FROM <TABLE NAME

Is it possible to delete duplicate rows in a table without
using a temporary table ?

Question Posted / krishnaraj p n

12 Answers
25216 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / krishnaraj p n

Can be done in a simple way.

DELETE FROM <TABLE NAME > WHERE <COLUMN NAME >IN
(
SELECT <COLUMN NAME> FROM <TABLE NAME >
GROUP BY <COLUMN NAME>
HAVING COUNT(<COLUMN NAME>) > 1
)

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the difference between clustered and non-clustered index?

870

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

919

What are the kinds of subquery?

951

Can we use max in where clause?

880

Can you type more than one query in the query editor screen at the same time?

953

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1624

what is blocking? : Sql server database administration

981

List out the differences between the clustered index and non-clustered index in sql server?

944

New concepts of sql server 2005 use in your project.

2303

Explain how to send email from sql database?

973

how many bits ip address consist of? : Sql server database administration

847

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

905

Write a sql query to display the current date?

1028

How to find the list of fixed hard drive and free space on server?

1096

Can we add a cpu to sql server?

958