How can we delete duplicate records in a table without using rowid() func

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

Question Posted / preetpal kapoor

Answer Posted / preetpal kapoor

How can we delete duplicate records in a table without
using rowid() function and temporary table?

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain indexed views?

1025

Explain transaction server distributed transaction?

1028

What is the importance of three tier architecture?

1141

How you can move data or databases between servers and databases in sql server?

1095

what's the difference between delete table and truncate table commands? : Sql server database administration

1032

How to use values from other tables in update statements in ms sql server?

1177

What are sql servers used for?

1107

How to identify current user in ssrs report?

408

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

957

Introduction of rollup clause using sum and group by clause?

1004

What is report subscription?

132

Explain cdc and sql injection?

1039

What is implicit cursors?

1125

What is the purpose of optimization?

1054

Explain what is cte (common table expression)?

1181