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 table value parameters (tvp)?

1090

What do you understand by integration services in sql server?

955

what is an index? : Sql server database administration

968

List all types of constraints in sql server?

996

What are indexes in sql?

1266

What is the use of floor function in sql server?

1071

What is the difference in accessing db between sql server vs sql azure?

174

What is the difference between for auto and for nested?

995

How to change server name in sql server?

1172

Can we write a distributed query and get some data which is located on other server and oracle database?

1217

What is key set driven?

942

What are data resources?

901

What is xml datatype?

1069

What is onf in normalization form?

1046

what are the types of indexes? : Sql server database administration

1105