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

What is deploy, process and build? : sql server analysis services, ssas

1043

what is an index? : Sql server database administration

939

Is truncate a dml command?

897

How to delete duplicate rows?

940

Can I work with several databases simultaneously? : sql server management studio

951

Why should one not prefix user stored procedures with ‘sp_’?

994

What is data source document?

983

How to how to convert numeric expression data types using the convert() function??

996

What are advantages of ssrs or why we should use ssrs?

133

What is a view and what are its advantages?

1059

What is openrowset sql server?

1075

What are the types of indexing?

1036

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

884

What is the difference between functions and stored procedures?

1100

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

988