If u no know the ROWID then u can delete the duplicate rows.

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

Question Posted / nithya

Answer Posted / nithya

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is optimization and its types?

929

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

893

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

149

Define indexes?

1006

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1179

Why we use functions in sql server?

1026

What are joins in sql and what are the different types of joins?

976

How to remove duplicate rows from table?

1183

What do you mean by an execution plan? Why is it used?

963

What is catalog views?

1032

Mention what are the core components of ssrs?

298

Explain what are page splits? : SQL Server Architecture

1014

What are the different types of sql server replication? : sql server replication

1183

Explain the properties of a relational table?

988

What are trace flags and mention a few common trace flags used with sql server?

1049