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

How do database indexes work?

1009

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

1005

Is mysql the same as sql server?

985

Explain identity in sql server?

1008

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1013

What do you mean by a Composite primary key?

1103

How to disable triggers using "disable trigger"?

1056

How to attach adventureworkslt physical files to the server?

1106

How can you find out which stored procedures are recompiling?

918

What are sql servers used for?

1047

What is self contained scalar sub query?

974

What is sql service broker?

982

How to convert a unicode strings to non-unicode strings?

1102

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1965

How do I find the sql server instance name?

967