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 is table type constraint applied to a table?

1023

How we create SQL Server 2005 Reporting Services ? Give me Sample

2043

What do you do in data exploration

1050

How to select all columns of all rows from a table with a select statement in ms sql server?

1195

Is null in sql server?

1042

When a primary key constraint is included in a table, what other constraints does this imply?

1021

What are secondary xml indexes?

1076

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1088

How do you manipulate data?

949

Do you know nested transaction?

1001

How can you check the version of sql server?

1158

What happens if you are trying to access a schema not owned by you?

1020

Does group by or order by come first?

996

What is Extended user-defined?

1029

What is the maximum rows in sql server table?

962