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

Answer Posted / nithya

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What area unit the various kinds of info compression introduced in sql server 2008?

560


What is the use of =,==,=== operators?

564


Why are you getting errors when creating a new odbc dsn?

577


What is create command?

516


What program is used to store the data source file?

496






what are the different stages of Report Processing?

97


How do you delete duplicate records in sql server?

500


Explain a checkpoint?

528


When we should use @@error?

530


What triggers long term care?

552


Can we do dml on views?

542


Explain the different index configurations a table can have?

496


What is merge replication?

702


Explain the types of indexes.

628


What is co-related sub query?

555