if 3 duplicate records in a table,i want to delete 2 duplicate
records by keeping 1 duplicate and 1 original as it is,how?
Answer Posted / siva raman
By using Rank function we can delete duplicate records in
tables.
Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are indexers?
What is a rollup clause?
Mention the differences between substr and charindex in sql server.
why would you use sql agent? : Sql server database administration
What is b tree index?
How to retrieve error messages using odbc_errormsg()?
What are the essential components of sql server service broker?
What is blocking?
How dts is used to extract, transform and consolidate data?
What is the difference between a local and a global temporary table?
You want to use a perspective in an mdx query. How do you select the perspective?
What are the new features are introduced in sql server 2012 reporting services?
Explain mixed authentication mode of sql server?
If we delete pack Spec what will be the status of pack Body ?
What are the properties of the relational tables?