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

what's sql server? : Sql server database administration

938

what are different types of raid configurations? : Sql server database administration

1001

Explain different types of self contained sub query?

959

When would you use sql joins?

917

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

850

What is the sql profiler?

908

When would you use the stored procedures or functions?

954

Can you tell me about the concept of ER diagrams?

1025

Explain what are page splits? : SQL Server Architecture

1008

What happens to a trigger with multiple affected rows?

878

What is after dml trigger?

967

What is a covered index?

898

What is the order by used for?

975

what is raid and what are different types of raid configurations? : Sql server database administration

981

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

918