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 are scheduled tasks in sql server?

1011

How to write a query with a full outer join in ms sql server?

1001

in the physical file layout, where should the transaction log be stored in relation to the data file?

943

What do you think of this implementation? Can this be implemented better?

877

Explain transaction server isolation?

982

What is clustered index

953

How will you add a dimension to cube? : sql server analysis services, ssas

1012

what is a live lock? : Sql server database administration

888

Explain the use of keyword with encryption. Create a store procedure with encryption?

898

What is the difference between for trigger and after trigger?

1028

What is inner join? Explain with an example?

1120

What are built in functions?

954

How to create a scrollable cursor with the scroll option?

928

What is a user-defined function in the sql server and what is its advantage?

1046

How many databases instances are there in sql server 2000?

1025