Is it possible to delete duplicate rows in a table without
using a temporary table ?
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 |
Post New Answer View All Answers
What are the tool windows in sql server management studio? : sql server management studio
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
how to determine the service pack currently installed on sql server? : Sql server database administration
What is transaction server consistency?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What are views used for?
What is database mirroring?
What are the advantages of the mirroring?
What is difference between commit and rollback when used in transactions?
Explain what are page splits? : SQL Server Architecture
What are “phantom rows”?
Explain about link server in sql server?
Does sql server 2000 clustering support load balancing?
What are the pre-defined functions in the sql server?
Do you know what is sql service broker?