Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 8573 Views
- I also Faced
- E-Mail Answers
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 is a schema in ms sql server 2005?
How to delete existing rows in a table?
When is update_statistics command used?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How to execute stored procedure and set temp table in sql server?
how many layers of tcp/ip protocol combined of? : Sql server database administration
How to start sql server browser service?
Difference between DELETE and TRUNCATE?
What is the Main Difference between ACCESS and SQL SERVER?
What is factless fact table? : sql server analysis services, ssas
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is use of except clause?
What are different types of raid levels?
What happens to a statement batch if there is a compilation error?
What are the advantages of policy management?
