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
What is optimization and its types?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
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?
Define indexes?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Why we use functions in sql server?
What are joins in sql and what are the different types of joins?
How to remove duplicate rows from table?
What do you mean by an execution plan? Why is it used?
What is catalog views?
Mention what are the core components of ssrs?
Explain what are page splits? : SQL Server Architecture
What are the different types of sql server replication? : sql server replication
Explain the properties of a relational table?
What are trace flags and mention a few common trace flags used with sql server?